library(datasets)
First lets bring in the Pokemon dataset.
Pokemon = read.csv(file = 'data/Pokemon.csv')
head(Pokemon)
## X. Name Type.1 Type.2 Total HP Attack Defense Sp..Atk
## 1 1 Bulbasaur Grass Poison 318 45 49 49 65
## 2 2 Ivysaur Grass Poison 405 60 62 63 80
## 3 3 Venusaur Grass Poison 525 80 82 83 100
## 4 3 VenusaurMega Venusaur Grass Poison 625 80 100 123 122
## 5 4 Charmander Fire 309 39 52 43 60
## 6 5 Charmeleon Fire 405 58 64 58 80
## Sp..Def Speed Generation Legendary
## 1 65 45 1 False
## 2 80 60 1 False
## 3 100 80 1 False
## 4 120 80 1 False
## 5 50 65 1 False
## 6 65 80 1 False
What is the most common type for pokemon?
Since there are secondary typing for Pokemon, we will have to combine the observations from the two variables.
But first lets see what the data shows for Pokemon that only have one type.
# this is the Type.2 for charmander
# a Pokemon that has a singular "Fire" type
Pokemon$Type.2[5]
## [1] ""
The data displays a “” or empty for a Pokemon that has to Type.2. This will muddy our data if we’re looking for the most common type, since technically “” is a valid observation as far as the code is concerned.
These are the tables for Type.1 and Type.2 variables.
table(Pokemon$Type.1)
##
## Bug Dark Dragon Electric Fairy Fighting Fire Flying
## 69 31 32 44 17 27 52 4
## Ghost Grass Ground Ice Normal Poison Psychic Rock
## 32 70 32 24 98 28 57 44
## Steel Water
## 27 112
table(Pokemon$Type.2)
##
## Bug Dark Dragon Electric Fairy Fighting Fire
## 386 3 20 18 6 23 26 12
## Flying Ghost Grass Ground Ice Normal Poison Psychic
## 97 14 25 35 14 4 34 33
## Rock Steel Water
## 14 22 14
# how many types are in Type.1
length(table(Pokemon$Type.1))
## [1] 18
# how many types are in Type.2
length(table(Pokemon$Type.2))
## [1] 19
As you can see there is an extra type in
table(Pokemon$Type.2) that is “” with the number 386 to
represent all of the observations/Pokemon with “” for Type.2.
This is the combined table of Type.1 and Type.2, minus the empty
“” type Now we need to be careful, because this does not represent every
Pokemon. As you can see when we look at the sum of the table, it shows
1214 when we only have 800 observations/Pokemon.
combinedTypeTable = (table(Pokemon$Type.1) + table(Pokemon$Type.2)[-1])
paste("The sum is: ", sum(combinedTypeTable))
## [1] "The sum is: 1214"
Finally lets see which type is the most common for pokemon, either as their Type.1 OR their Type.2.
# finds the max(table), and then finds the index of the max value, then returns both the number and its name, in our case the type
combinedTypeTable[which(combinedTypeTable == max(combinedTypeTable))]
## Water
## 126
As you can see, the most common typing for a Pokemon is Water.
But as always a visualization will help in contextualizing this piece of information.
combinedTypeTable = sort(combinedTypeTable, decreasing=TRUE)
barplot(combinedTypeTable[1:5], main = "TOP 5 MOST COMMON TYPES IN POKEMON", ylab="Frequency", col=c("lightblue"))
What generation has the greatest number of each “type”(Type.1 and Type.2 combined) of Pokemon
First we need to know how many different generations are present in our data.
table(Pokemon$Generation)
##
## 1 2 3 4 5 6
## 166 106 160 121 165 82
There are 6 different generations of Pokemon listed in the data, with a varying number of Pokemon for each generation.
Now we need to parse the data so that we can see how many of each type is in each generation.
# table for the number of each Type.1 type for all entries where the Generation is 1
table(Pokemon$Type.1[which(Pokemon$Generation == 1)])
##
## Bug Dragon Electric Fairy Fighting Fire Ghost Grass
## 14 3 9 2 7 14 4 13
## Ground Ice Normal Poison Psychic Rock Water
## 8 2 24 14 11 10 31
# table for the number of each Type.2 type for all entries where the Generation is 1
table(Pokemon$Type.2[which(Pokemon$Generation == 1)])
##
## Dark Dragon Fairy Fighting Flying Grass Ground
## 88 1 1 3 2 23 2 6
## Ice Poison Psychic Rock Steel Water
## 3 22 7 2 2 4
length(table(Pokemon$Type.1[which(Pokemon$Generation == 1)]))
## [1] 15
length(table(Pokemon$Type.2[which(Pokemon$Generation == 1)]))
## [1] 14
But we run in to a problem due to the way that Pokemon types are set up. A Pokemon has one or two types, and the Type.2 is valued the same as Type.1. This means that we need to count both when looking at how many types of each Pokemon are in each generation. For example the first Pokemon in the data, Bulbasaur, would count as both a “Grass” and “Poison” type, with both holding equal weight. This causes discrepancies like we see above, where some types are missing from the Type.2 table and the Type.1 table . We will have to modify the table ourselves to make this work.
Since we will most likely have to do this for every generation, lets make a function that fills in the missing “types” and returns one vector with the combined values for both Type.1 and Type.2
# this function will help us combine the two Type tables int o one table with all unique types from both Type.1 and Type.2, as well as add up duplicates
combineTypeTblByGen = function(generation){
# merging the table of Type.1 and Type.2 for the generation
mergedTypeTable = merge(table(Pokemon$Type.1[which(Pokemon$Generation == generation)]), table(Pokemon$Type.2[which(Pokemon$Generation == generation)])[-1], all= TRUE)
# vector version of the merged tables above
typeVec = mergedTypeTable[[2]]
names(typeVec) = mergedTypeTable[[1]]
# for loop that adds up the repeat values for the types, and then removes the duplicate name+value from the vector
len = length(typeVec) - 1
for(i in 1:len){
if(i >= length(typeVec)){break}
else if(names(typeVec[i]) == names(typeVec[i + 1])){
typeVec[i+1] = typeVec[i] + typeVec[i+1]
#print(typeVec[i])
typeVec = typeVec[-c(i)]
}
}
return(typeVec)
}
barplot(combineTypeTblByGen(1), las=2, main="Frequency of Types for Generation 1")
The plot above combines frequency of “types” in both Type1 and Type2 for generation 1, and because we have the function combineTypeTblByGen() we are able to replicate this for every other generation as well.
Since we have the combined tables for every generation, we can move on to comparing the generations by Type.
This next function will allow us to see how many of one specific type is in every generation. For example it will allow us to see the number of “Bug” types there are in generation 1 through 6.
# function takes in a character argument that represents a Pokemon Type and returns a vector of length 6, with each index representing the number of that type of pokemon are in that generation number
compareTypeAcrossGen = function(type){
oneTypeAllGensVec = c()
for(i in 1:6){
#print(combineTypeTblByGen(i)[type])
oneTypeAllGensVec[i] = combineTypeTblByGen(i)[type]
}
names(oneTypeAllGensVec) = c("Gen 1", "Gen 2", "Gen 3", "Gen 4", "Gen 5", "Gen 6")
return(oneTypeAllGensVec)
}
compareTypeAcrossGen("Bug")
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 14 12 14 11 18 3
compareTypeAcrossGen("Dark")
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 1 8 13 7 16 3
barplot(compareTypeAcrossGen("Bug"), main="Frequency of Bug Types in Each Generation(Gen)", las=2, col = "lightgreen")
We have the comparisons across generations for individual types, but that doesn’t accomplish anything unless we want to create 18 different barplots. Instead lets use the plotly package to create an interactive barplot that shows the frequency of each type across the generations to get a broader understanding of the dataset.
typeByGenTraces[]
## [[1]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 14 12 14 11 18 3
##
## [[2]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 4 2 15 4 12 9
##
## [[3]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 9 9 5 12 12 3
##
## [[4]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 5 8 8 1 3 14
##
## [[5]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 9 2 9 10 17 4
##
## [[6]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 14 11 9 6 16 8
##
## [[7]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 4 1 8 9 9 15
##
## [[8]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 15 10 18 17 20 15
##
## [[9]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 14 11 16 12 12 2
##
## [[10]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 5 5 7 8 9 2
##
## [[11]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 24 15 18 18 19 4
##
## [[12]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 36 4 5 8 7 2
##
## [[13]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 18 10 28 10 16 8
##
## [[14]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 12 8 12 7 10 9
##
## [[15]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 35 18 31 15 18 9
##
## [[16]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 1 8 13 7 16 3
##
## [[17]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 23 19 14 16 21 8
##
## [[18]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6
## 2 3 12 12 12 5
q2FinalGraph
library(DBI)
library(RSQLite)
## Warning: package 'RSQLite' was built under R version 4.4.3
drv = dbDriver("SQLite")
pokemonDatabase = dbConnect(drv, dbname = "./data/veekun-pokedex.sqlite")
dbExecute(pokemonDatabase, "PRAGMA foreign_keys = on")
## [1] 0
dbListTables(pokemonDatabase)
## [1] "abilities" "ability_changelog"
## [3] "ability_changelog_prose" "ability_flavor_text"
## [5] "ability_names" "ability_prose"
## [7] "berries" "berry_firmness"
## [9] "berry_firmness_names" "berry_flavors"
## [11] "characteristic_text" "characteristics"
## [13] "conquest_episode_names" "conquest_episode_warriors"
## [15] "conquest_episodes" "conquest_kingdom_names"
## [17] "conquest_kingdoms" "conquest_max_links"
## [19] "conquest_move_data" "conquest_move_displacement_prose"
## [21] "conquest_move_displacements" "conquest_move_effect_prose"
## [23] "conquest_move_effects" "conquest_move_range_prose"
## [25] "conquest_move_ranges" "conquest_pokemon_abilities"
## [27] "conquest_pokemon_evolution" "conquest_pokemon_moves"
## [29] "conquest_pokemon_stats" "conquest_stat_names"
## [31] "conquest_stats" "conquest_transformation_pokemon"
## [33] "conquest_transformation_warriors" "conquest_warrior_archetypes"
## [35] "conquest_warrior_names" "conquest_warrior_rank_stat_map"
## [37] "conquest_warrior_ranks" "conquest_warrior_skill_names"
## [39] "conquest_warrior_skills" "conquest_warrior_specialties"
## [41] "conquest_warrior_stat_names" "conquest_warrior_stats"
## [43] "conquest_warrior_transformation" "conquest_warriors"
## [45] "contest_combos" "contest_effect_prose"
## [47] "contest_effects" "contest_type_names"
## [49] "contest_types" "egg_group_prose"
## [51] "egg_groups" "encounter_condition_prose"
## [53] "encounter_condition_value_map" "encounter_condition_value_prose"
## [55] "encounter_condition_values" "encounter_conditions"
## [57] "encounter_method_prose" "encounter_methods"
## [59] "encounter_slots" "encounters"
## [61] "evolution_chains" "evolution_trigger_prose"
## [63] "evolution_triggers" "experience"
## [65] "genders" "generation_names"
## [67] "generations" "growth_rate_prose"
## [69] "growth_rates" "item_categories"
## [71] "item_category_prose" "item_flag_map"
## [73] "item_flag_prose" "item_flags"
## [75] "item_flavor_summaries" "item_flavor_text"
## [77] "item_fling_effect_prose" "item_fling_effects"
## [79] "item_game_indices" "item_names"
## [81] "item_pocket_names" "item_pockets"
## [83] "item_prose" "items"
## [85] "language_names" "languages"
## [87] "location_area_encounter_rates" "location_area_prose"
## [89] "location_areas" "location_game_indices"
## [91] "location_names" "locations"
## [93] "machines" "move_battle_style_prose"
## [95] "move_battle_styles" "move_changelog"
## [97] "move_damage_class_prose" "move_damage_classes"
## [99] "move_effect_changelog" "move_effect_changelog_prose"
## [101] "move_effect_prose" "move_effects"
## [103] "move_flag_map" "move_flag_prose"
## [105] "move_flags" "move_flavor_summaries"
## [107] "move_flavor_text" "move_meta"
## [109] "move_meta_ailment_names" "move_meta_ailments"
## [111] "move_meta_categories" "move_meta_category_prose"
## [113] "move_meta_stat_changes" "move_names"
## [115] "move_target_prose" "move_targets"
## [117] "moves" "nature_battle_style_preferences"
## [119] "nature_names" "nature_pokeathlon_stats"
## [121] "natures" "pal_park"
## [123] "pal_park_area_names" "pal_park_areas"
## [125] "pokeathlon_stat_names" "pokeathlon_stats"
## [127] "pokedex_prose" "pokedex_version_groups"
## [129] "pokedexes" "pokemon"
## [131] "pokemon_abilities" "pokemon_color_names"
## [133] "pokemon_colors" "pokemon_dex_numbers"
## [135] "pokemon_egg_groups" "pokemon_evolution"
## [137] "pokemon_form_generations" "pokemon_form_names"
## [139] "pokemon_form_pokeathlon_stats" "pokemon_forms"
## [141] "pokemon_game_indices" "pokemon_habitat_names"
## [143] "pokemon_habitats" "pokemon_items"
## [145] "pokemon_move_method_prose" "pokemon_move_methods"
## [147] "pokemon_moves" "pokemon_shape_prose"
## [149] "pokemon_shapes" "pokemon_species"
## [151] "pokemon_species_flavor_summaries" "pokemon_species_flavor_text"
## [153] "pokemon_species_names" "pokemon_species_prose"
## [155] "pokemon_stats" "pokemon_types"
## [157] "region_names" "regions"
## [159] "stat_names" "stats"
## [161] "super_contest_combos" "super_contest_effect_prose"
## [163] "super_contest_effects" "type_efficacy"
## [165] "type_game_indices" "type_names"
## [167] "types" "version_group_pokemon_move_methods"
## [169] "version_group_regions" "version_groups"
## [171] "version_names" "versions"
This database and tables needs to be “cleaned” or organized into the
information that I actually need –> practice organizing and putting
data togehter with joins
Questions to ask/analyze:
how has the stats fro certain types changed over the course of the
generartions?
is this change significant?
Pokedex app? image, stats, and reads pokedex entry? check normality for stats by type
hypothesis: flying types are significantly faster than ground, check?
When I think of flying type Pokemon, I imagine fast aerial predators,
so naturally you would think that their speed stat is significantly
higher than that of ground/rock types that are usually large boulders
and giants. But do the stats, get it?, actually back this up?
Lets Find Out!
Step 1: get a data frame with every flying type and their
speed stat and every ground type and their speed stat
Lets build this dataframe step by step.
Step 1a: get a dataframe with every Pokemon and its speed
stat
dbGetQuery(pokemonDatabase,
"PRAGMA FOREIGN_KEY_LIST(pokemon_stats)")
## id seq table from to on_update on_delete match
## 1 0 0 stats stat_id id NO ACTION NO ACTION NONE
## 2 1 0 pokemon pokemon_id id NO ACTION NO ACTION NONE
dbGetQuery(pokemonDatabase, "
SELECT pokemon_id, identifier, base_stat
FROM pokemon_stats INNER JOIN stats
ON pokemon_stats.stat_id = stats.id
WHERE identifier = 'speed'")
## pokemon_id identifier base_stat
## 1 1 speed 45
## 2 2 speed 60
## 3 3 speed 80
## 4 4 speed 65
## 5 5 speed 80
## 6 6 speed 100
## 7 7 speed 43
## 8 8 speed 58
## 9 9 speed 78
## 10 10 speed 45
## 11 11 speed 30
## 12 12 speed 70
## 13 13 speed 50
## 14 14 speed 35
## 15 15 speed 75
## 16 16 speed 56
## 17 17 speed 71
## 18 18 speed 101
## 19 19 speed 72
## 20 20 speed 97
## 21 21 speed 70
## 22 22 speed 100
## 23 23 speed 55
## 24 24 speed 80
## 25 25 speed 90
## 26 26 speed 110
## 27 27 speed 40
## 28 28 speed 65
## 29 29 speed 41
## 30 30 speed 56
## 31 31 speed 76
## 32 32 speed 50
## 33 33 speed 65
## 34 34 speed 85
## 35 35 speed 35
## 36 36 speed 60
## 37 37 speed 65
## 38 38 speed 100
## 39 39 speed 20
## 40 40 speed 45
## 41 41 speed 55
## 42 42 speed 90
## 43 43 speed 30
## 44 44 speed 40
## 45 45 speed 50
## 46 46 speed 25
## 47 47 speed 30
## 48 48 speed 45
## 49 49 speed 90
## 50 50 speed 95
## 51 51 speed 120
## 52 52 speed 90
## 53 53 speed 115
## 54 54 speed 55
## 55 55 speed 85
## 56 56 speed 70
## 57 57 speed 95
## 58 58 speed 60
## 59 59 speed 95
## 60 60 speed 90
## 61 61 speed 90
## 62 62 speed 70
## 63 63 speed 90
## 64 64 speed 105
## 65 65 speed 120
## 66 66 speed 35
## 67 67 speed 45
## 68 68 speed 55
## 69 69 speed 40
## 70 70 speed 55
## 71 71 speed 70
## 72 72 speed 70
## 73 73 speed 100
## 74 74 speed 20
## 75 75 speed 35
## 76 76 speed 45
## 77 77 speed 90
## 78 78 speed 105
## 79 79 speed 15
## 80 80 speed 30
## 81 81 speed 45
## 82 82 speed 70
## 83 83 speed 60
## 84 84 speed 75
## 85 85 speed 100
## 86 86 speed 45
## 87 87 speed 70
## 88 88 speed 25
## 89 89 speed 50
## 90 90 speed 40
## 91 91 speed 70
## 92 92 speed 80
## 93 93 speed 95
## 94 94 speed 110
## 95 95 speed 70
## 96 96 speed 42
## 97 97 speed 67
## 98 98 speed 50
## 99 99 speed 75
## 100 100 speed 100
## 101 101 speed 140
## 102 102 speed 40
## 103 103 speed 55
## 104 104 speed 35
## 105 105 speed 45
## 106 106 speed 87
## 107 107 speed 76
## 108 108 speed 30
## 109 109 speed 35
## 110 110 speed 60
## 111 111 speed 25
## 112 112 speed 40
## 113 113 speed 50
## 114 114 speed 60
## 115 115 speed 90
## 116 116 speed 60
## 117 117 speed 85
## 118 118 speed 63
## 119 119 speed 68
## 120 120 speed 85
## 121 121 speed 115
## 122 122 speed 90
## 123 123 speed 105
## 124 124 speed 95
## 125 125 speed 105
## 126 126 speed 93
## 127 127 speed 85
## 128 128 speed 110
## 129 129 speed 80
## 130 130 speed 81
## 131 131 speed 60
## 132 132 speed 48
## 133 133 speed 55
## 134 134 speed 65
## 135 135 speed 130
## 136 136 speed 65
## 137 137 speed 40
## 138 138 speed 35
## 139 139 speed 55
## 140 140 speed 55
## 141 141 speed 80
## 142 142 speed 130
## 143 143 speed 30
## 144 144 speed 85
## 145 145 speed 100
## 146 146 speed 90
## 147 147 speed 50
## 148 148 speed 70
## 149 149 speed 80
## 150 150 speed 130
## 151 151 speed 100
## 152 152 speed 45
## 153 153 speed 60
## 154 154 speed 80
## 155 155 speed 65
## 156 156 speed 80
## 157 157 speed 100
## 158 158 speed 43
## 159 159 speed 58
## 160 160 speed 78
## 161 161 speed 20
## 162 162 speed 90
## 163 163 speed 50
## 164 164 speed 70
## 165 165 speed 55
## 166 166 speed 85
## 167 167 speed 30
## 168 168 speed 40
## 169 169 speed 130
## 170 170 speed 67
## 171 171 speed 67
## 172 172 speed 60
## 173 173 speed 15
## 174 174 speed 15
## 175 175 speed 20
## 176 176 speed 40
## 177 177 speed 70
## 178 178 speed 95
## 179 179 speed 35
## 180 180 speed 45
## 181 181 speed 55
## 182 182 speed 50
## 183 183 speed 40
## 184 184 speed 50
## 185 185 speed 30
## 186 186 speed 70
## 187 187 speed 50
## 188 188 speed 80
## 189 189 speed 110
## 190 190 speed 85
## 191 191 speed 30
## 192 192 speed 30
## 193 193 speed 95
## 194 194 speed 15
## 195 195 speed 35
## 196 196 speed 110
## 197 197 speed 65
## 198 198 speed 91
## 199 199 speed 30
## 200 200 speed 85
## 201 201 speed 48
## 202 202 speed 33
## 203 203 speed 85
## 204 204 speed 15
## 205 205 speed 40
## 206 206 speed 45
## 207 207 speed 85
## 208 208 speed 30
## 209 209 speed 30
## 210 210 speed 45
## 211 211 speed 85
## 212 212 speed 65
## 213 213 speed 5
## 214 214 speed 85
## 215 215 speed 115
## 216 216 speed 40
## 217 217 speed 55
## 218 218 speed 20
## 219 219 speed 30
## 220 220 speed 50
## 221 221 speed 50
## 222 222 speed 35
## 223 223 speed 65
## 224 224 speed 45
## 225 225 speed 75
## 226 226 speed 70
## 227 227 speed 70
## 228 228 speed 65
## 229 229 speed 95
## 230 230 speed 85
## 231 231 speed 40
## 232 232 speed 50
## 233 233 speed 60
## 234 234 speed 85
## 235 235 speed 75
## 236 236 speed 35
## 237 237 speed 70
## 238 238 speed 65
## 239 239 speed 95
## 240 240 speed 83
## 241 241 speed 100
## 242 242 speed 55
## 243 243 speed 115
## 244 244 speed 100
## 245 245 speed 85
## 246 246 speed 41
## 247 247 speed 51
## 248 248 speed 61
## 249 249 speed 110
## 250 250 speed 90
## 251 251 speed 100
## 252 252 speed 70
## 253 253 speed 95
## 254 254 speed 120
## 255 255 speed 45
## 256 256 speed 55
## 257 257 speed 80
## 258 258 speed 40
## 259 259 speed 50
## 260 260 speed 60
## 261 261 speed 35
## 262 262 speed 70
## 263 263 speed 60
## 264 264 speed 100
## 265 265 speed 20
## 266 266 speed 15
## 267 267 speed 65
## 268 268 speed 15
## 269 269 speed 65
## 270 270 speed 30
## 271 271 speed 50
## 272 272 speed 70
## 273 273 speed 30
## 274 274 speed 60
## 275 275 speed 80
## 276 276 speed 85
## 277 277 speed 125
## 278 278 speed 85
## 279 279 speed 65
## 280 280 speed 40
## 281 281 speed 50
## 282 282 speed 80
## 283 283 speed 65
## 284 284 speed 60
## 285 285 speed 35
## 286 286 speed 70
## 287 287 speed 30
## 288 288 speed 90
## 289 289 speed 100
## 290 290 speed 40
## 291 291 speed 160
## 292 292 speed 40
## 293 293 speed 28
## 294 294 speed 48
## 295 295 speed 68
## 296 296 speed 25
## 297 297 speed 50
## 298 298 speed 20
## 299 299 speed 30
## 300 300 speed 50
## 301 301 speed 70
## 302 302 speed 50
## 303 303 speed 50
## 304 304 speed 30
## 305 305 speed 40
## 306 306 speed 50
## 307 307 speed 60
## 308 308 speed 80
## 309 309 speed 65
## 310 310 speed 105
## 311 311 speed 95
## 312 312 speed 95
## 313 313 speed 85
## 314 314 speed 85
## 315 315 speed 65
## 316 316 speed 40
## 317 317 speed 55
## 318 318 speed 65
## 319 319 speed 95
## 320 320 speed 60
## 321 321 speed 60
## 322 322 speed 35
## 323 323 speed 40
## 324 324 speed 20
## 325 325 speed 60
## 326 326 speed 80
## 327 327 speed 60
## 328 328 speed 10
## 329 329 speed 70
## 330 330 speed 100
## 331 331 speed 35
## 332 332 speed 55
## 333 333 speed 50
## 334 334 speed 80
## 335 335 speed 90
## 336 336 speed 65
## 337 337 speed 70
## 338 338 speed 70
## 339 339 speed 60
## 340 340 speed 60
## 341 341 speed 35
## 342 342 speed 55
## 343 343 speed 55
## 344 344 speed 75
## 345 345 speed 23
## 346 346 speed 43
## 347 347 speed 75
## 348 348 speed 45
## 349 349 speed 80
## 350 350 speed 81
## 351 351 speed 70
## 352 352 speed 40
## 353 353 speed 45
## 354 354 speed 65
## 355 355 speed 25
## 356 356 speed 25
## 357 357 speed 51
## 358 358 speed 65
## 359 359 speed 75
## 360 360 speed 23
## 361 361 speed 50
## 362 362 speed 80
## 363 363 speed 25
## 364 364 speed 45
## 365 365 speed 65
## 366 366 speed 32
## 367 367 speed 52
## 368 368 speed 52
## 369 369 speed 55
## 370 370 speed 97
## 371 371 speed 50
## 372 372 speed 50
## 373 373 speed 100
## 374 374 speed 30
## 375 375 speed 50
## 376 376 speed 70
## 377 377 speed 50
## 378 378 speed 50
## 379 379 speed 50
## 380 380 speed 110
## 381 381 speed 110
## 382 382 speed 90
## 383 383 speed 90
## 384 384 speed 95
## 385 385 speed 100
## 386 386 speed 150
## 387 387 speed 31
## 388 388 speed 36
## 389 389 speed 56
## 390 390 speed 61
## 391 391 speed 81
## 392 392 speed 108
## 393 393 speed 40
## 394 394 speed 50
## 395 395 speed 60
## 396 396 speed 60
## 397 397 speed 80
## 398 398 speed 100
## 399 399 speed 31
## 400 400 speed 71
## 401 401 speed 25
## 402 402 speed 65
## 403 403 speed 45
## 404 404 speed 60
## 405 405 speed 70
## 406 406 speed 55
## 407 407 speed 90
## 408 408 speed 58
## 409 409 speed 58
## 410 410 speed 30
## 411 411 speed 30
## 412 412 speed 36
## 413 413 speed 36
## 414 414 speed 66
## 415 415 speed 70
## 416 416 speed 40
## 417 417 speed 95
## 418 418 speed 85
## 419 419 speed 115
## 420 420 speed 35
## 421 421 speed 85
## 422 422 speed 34
## 423 423 speed 39
## 424 424 speed 115
## 425 425 speed 70
## 426 426 speed 80
## 427 427 speed 85
## 428 428 speed 105
## 429 429 speed 105
## 430 430 speed 71
## 431 431 speed 85
## 432 432 speed 112
## 433 433 speed 45
## 434 434 speed 74
## 435 435 speed 84
## 436 436 speed 23
## 437 437 speed 33
## 438 438 speed 10
## 439 439 speed 60
## 440 440 speed 30
## 441 441 speed 91
## 442 442 speed 35
## 443 443 speed 42
## 444 444 speed 82
## 445 445 speed 102
## 446 446 speed 5
## 447 447 speed 60
## 448 448 speed 90
## 449 449 speed 32
## 450 450 speed 47
## 451 451 speed 65
## 452 452 speed 95
## 453 453 speed 50
## 454 454 speed 85
## 455 455 speed 46
## 456 456 speed 66
## 457 457 speed 91
## 458 458 speed 50
## 459 459 speed 40
## 460 460 speed 60
## 461 461 speed 125
## 462 462 speed 60
## 463 463 speed 50
## 464 464 speed 40
## 465 465 speed 50
## 466 466 speed 95
## 467 467 speed 83
## 468 468 speed 80
## 469 469 speed 95
## 470 470 speed 95
## 471 471 speed 65
## 472 472 speed 95
## 473 473 speed 80
## 474 474 speed 90
## 475 475 speed 80
## 476 476 speed 40
## 477 477 speed 45
## 478 478 speed 110
## 479 479 speed 91
## 480 480 speed 95
## 481 481 speed 80
## 482 482 speed 115
## 483 483 speed 90
## 484 484 speed 100
## 485 485 speed 77
## 486 486 speed 100
## 487 487 speed 90
## 488 488 speed 85
## 489 489 speed 80
## 490 490 speed 100
## 491 491 speed 125
## 492 492 speed 100
## 493 493 speed 120
## 494 494 speed 100
## 495 495 speed 63
## 496 496 speed 83
## 497 497 speed 113
## 498 498 speed 45
## 499 499 speed 55
## 500 500 speed 65
## 501 501 speed 45
## 502 502 speed 60
## 503 503 speed 70
## 504 504 speed 42
## 505 505 speed 77
## 506 506 speed 55
## 507 507 speed 60
## 508 508 speed 80
## 509 509 speed 66
## 510 510 speed 106
## 511 511 speed 64
## 512 512 speed 101
## 513 513 speed 64
## 514 514 speed 101
## 515 515 speed 64
## 516 516 speed 101
## 517 517 speed 24
## 518 518 speed 29
## 519 519 speed 43
## 520 520 speed 65
## 521 521 speed 93
## 522 522 speed 76
## 523 523 speed 116
## 524 524 speed 15
## 525 525 speed 20
## 526 526 speed 25
## 527 527 speed 72
## 528 528 speed 114
## 529 529 speed 68
## 530 530 speed 88
## 531 531 speed 50
## 532 532 speed 35
## 533 533 speed 40
## 534 534 speed 45
## 535 535 speed 64
## 536 536 speed 69
## 537 537 speed 74
## 538 538 speed 45
## 539 539 speed 85
## 540 540 speed 42
## 541 541 speed 42
## 542 542 speed 92
## 543 543 speed 57
## 544 544 speed 47
## 545 545 speed 112
## 546 546 speed 66
## 547 547 speed 116
## 548 548 speed 30
## 549 549 speed 90
## 550 550 speed 98
## 551 551 speed 65
## 552 552 speed 74
## 553 553 speed 92
## 554 554 speed 50
## 555 555 speed 95
## 556 556 speed 60
## 557 557 speed 55
## 558 558 speed 45
## 559 559 speed 48
## 560 560 speed 58
## 561 561 speed 97
## 562 562 speed 30
## 563 563 speed 30
## 564 564 speed 22
## 565 565 speed 32
## 566 566 speed 70
## 567 567 speed 110
## 568 568 speed 65
## 569 569 speed 75
## 570 570 speed 65
## 571 571 speed 105
## 572 572 speed 75
## 573 573 speed 115
## 574 574 speed 45
## 575 575 speed 55
## 576 576 speed 65
## 577 577 speed 20
## 578 578 speed 30
## 579 579 speed 30
## 580 580 speed 55
## 581 581 speed 98
## 582 582 speed 44
## 583 583 speed 59
## 584 584 speed 79
## 585 585 speed 75
## 586 586 speed 95
## 587 587 speed 103
## 588 588 speed 60
## 589 589 speed 20
## 590 590 speed 15
## 591 591 speed 30
## 592 592 speed 40
## 593 593 speed 60
## 594 594 speed 65
## 595 595 speed 65
## 596 596 speed 108
## 597 597 speed 10
## 598 598 speed 20
## 599 599 speed 30
## 600 600 speed 50
## 601 601 speed 90
## 602 602 speed 60
## 603 603 speed 40
## 604 604 speed 50
## 605 605 speed 30
## 606 606 speed 40
## 607 607 speed 20
## 608 608 speed 55
## 609 609 speed 80
## 610 610 speed 57
## 611 611 speed 67
## 612 612 speed 97
## 613 613 speed 40
## 614 614 speed 50
## 615 615 speed 105
## 616 616 speed 25
## 617 617 speed 145
## 618 618 speed 32
## 619 619 speed 65
## 620 620 speed 105
## 621 621 speed 48
## 622 622 speed 35
## 623 623 speed 55
## 624 624 speed 60
## 625 625 speed 70
## 626 626 speed 55
## 627 627 speed 60
## 628 628 speed 80
## 629 629 speed 60
## 630 630 speed 80
## 631 631 speed 65
## 632 632 speed 109
## 633 633 speed 38
## 634 634 speed 58
## 635 635 speed 98
## 636 636 speed 60
## 637 637 speed 100
## 638 638 speed 108
## 639 639 speed 108
## 640 640 speed 108
## 641 641 speed 111
## 642 642 speed 111
## 643 643 speed 90
## 644 644 speed 90
## 645 645 speed 101
## 646 646 speed 95
## 647 647 speed 108
## 648 648 speed 90
## 649 649 speed 99
## 650 650 speed 38
## 651 651 speed 57
## 652 652 speed 64
## 653 653 speed 60
## 654 654 speed 73
## 655 655 speed 104
## 656 656 speed 71
## 657 657 speed 97
## 658 658 speed 122
## 659 659 speed 57
## 660 660 speed 78
## 661 661 speed 62
## 662 662 speed 84
## 663 663 speed 126
## 664 664 speed 35
## 665 665 speed 29
## 666 666 speed 89
## 667 667 speed 72
## 668 668 speed 106
## 669 669 speed 42
## 670 670 speed 52
## 671 671 speed 75
## 672 672 speed 52
## 673 673 speed 68
## 674 674 speed 43
## 675 675 speed 58
## 676 676 speed 102
## 677 677 speed 68
## 678 678 speed 104
## 679 679 speed 28
## 680 680 speed 35
## 681 681 speed 60
## 682 682 speed 23
## 683 683 speed 29
## 684 684 speed 49
## 685 685 speed 72
## 686 686 speed 45
## 687 687 speed 73
## 688 688 speed 50
## 689 689 speed 68
## 690 690 speed 30
## 691 691 speed 44
## 692 692 speed 44
## 693 693 speed 59
## 694 694 speed 70
## 695 695 speed 109
## 696 696 speed 48
## 697 697 speed 71
## 698 698 speed 46
## 699 699 speed 58
## 700 700 speed 60
## 701 701 speed 118
## 702 702 speed 101
## 703 703 speed 50
## 704 704 speed 40
## 705 705 speed 60
## 706 706 speed 80
## 707 707 speed 75
## 708 708 speed 38
## 709 709 speed 56
## 710 710 speed 51
## 711 711 speed 84
## 712 712 speed 28
## 713 713 speed 28
## 714 714 speed 55
## 715 715 speed 123
## 716 716 speed 99
## 717 717 speed 99
## 718 718 speed 95
## 719 719 speed 50
## 720 720 speed 70
## 721 721 speed 70
## 722 10001 speed 150
## 723 10002 speed 90
## 724 10003 speed 180
## 725 10004 speed 36
## 726 10005 speed 36
## 727 10006 speed 127
## 728 10007 speed 90
## 729 10008 speed 86
## 730 10009 speed 86
## 731 10010 speed 86
## 732 10011 speed 86
## 733 10012 speed 86
## 734 10013 speed 70
## 735 10014 speed 70
## 736 10015 speed 70
## 737 10016 speed 98
## 738 10017 speed 55
## 739 10018 speed 128
## 740 10019 speed 121
## 741 10020 speed 101
## 742 10021 speed 91
## 743 10022 speed 95
## 744 10023 speed 95
## 745 10024 speed 108
## 746 10025 speed 104
## 747 10026 speed 60
## 748 10027 speed 56
## 749 10028 speed 46
## 750 10029 speed 41
## 751 10030 speed 99
## 752 10031 speed 69
## 753 10032 speed 54
## 754 10033 speed 80
## 755 10034 speed 100
## 756 10035 speed 100
## 757 10036 speed 78
## 758 10037 speed 150
## 759 10038 speed 130
## 760 10039 speed 100
## 761 10040 speed 105
## 762 10041 speed 81
## 763 10042 speed 150
## 764 10043 speed 130
## 765 10044 speed 140
## 766 10045 speed 45
## 767 10046 speed 75
## 768 10047 speed 75
## 769 10048 speed 115
## 770 10049 speed 71
## 771 10050 speed 100
## 772 10051 speed 100
## 773 10052 speed 50
## 774 10053 speed 50
## 775 10054 speed 100
## 776 10055 speed 135
## 777 10056 speed 75
## 778 10057 speed 115
## 779 10058 speed 92
## 780 10059 speed 112
## 781 10060 speed 30
## 782 10061 speed 92
## 783 10062 speed 110
## 784 10063 speed 110
## 785 10064 speed 70
## 786 10065 speed 145
## 787 10066 speed 20
## 788 10067 speed 80
## 789 10068 speed 110
## 790 10069 speed 50
## 791 10070 speed 105
## 792 10071 speed 30
## 793 10072 speed 30
## 794 10073 speed 121
## 795 10074 speed 100
## 796 10075 speed 110
## 797 10076 speed 110
## 798 10077 speed 90
## 799 10078 speed 90
## 800 10079 speed 115
## 801 10080 speed 90
## 802 10081 speed 90
## 803 10082 speed 90
## 804 10083 speed 90
## 805 10084 speed 90
## 806 10085 speed 90
## 807 10086 speed 80
## 808 10087 speed 20
## 809 10088 speed 135
## 810 10089 speed 120
## 811 10090 speed 145
Step 1b: dataframe with every flying and ground type
# dbGetQuery(pokemonDatabase, "
# SELECT *
# FROM pokemon_types")
#
# dbGetQuery(pokemonDatabase, "
# PRAGMA FOREIGN_KEY_LIST(pokemon_types)")
#
# dbGetQuery(pokemonDatabase, "
# SELECT *
# FROM types")
dbGetQuery(pokemonDatabase, "
SELECT pokemon_id, slot, identifier as TYPE
FROM pokemon_types INNER JOIN types
ON pokemon_types.type_id = types.id
")
## pokemon_id slot TYPE
## 1 1 1 grass
## 2 1 2 poison
## 3 2 1 grass
## 4 2 2 poison
## 5 3 1 grass
## 6 3 2 poison
## 7 4 1 fire
## 8 5 1 fire
## 9 6 1 fire
## 10 6 2 flying
## 11 7 1 water
## 12 8 1 water
## 13 9 1 water
## 14 10 1 bug
## 15 11 1 bug
## 16 12 1 bug
## 17 12 2 flying
## 18 13 1 bug
## 19 13 2 poison
## 20 14 1 bug
## 21 14 2 poison
## 22 15 1 bug
## 23 15 2 poison
## 24 16 1 normal
## 25 16 2 flying
## 26 17 1 normal
## 27 17 2 flying
## 28 18 1 normal
## 29 18 2 flying
## 30 19 1 normal
## 31 20 1 normal
## 32 21 1 normal
## 33 21 2 flying
## 34 22 1 normal
## 35 22 2 flying
## 36 23 1 poison
## 37 24 1 poison
## 38 25 1 electric
## 39 26 1 electric
## 40 27 1 ground
## 41 28 1 ground
## 42 29 1 poison
## 43 30 1 poison
## 44 31 1 poison
## 45 31 2 ground
## 46 32 1 poison
## 47 33 1 poison
## 48 34 1 poison
## 49 34 2 ground
## 50 35 1 fairy
## 51 36 1 fairy
## 52 37 1 fire
## 53 38 1 fire
## 54 39 1 normal
## 55 39 2 fairy
## 56 40 1 normal
## 57 40 2 fairy
## 58 41 1 poison
## 59 41 2 flying
## 60 42 1 poison
## 61 42 2 flying
## 62 43 1 grass
## 63 43 2 poison
## 64 44 1 grass
## 65 44 2 poison
## 66 45 1 grass
## 67 45 2 poison
## 68 46 1 bug
## 69 46 2 grass
## 70 47 1 bug
## 71 47 2 grass
## 72 48 1 bug
## 73 48 2 poison
## 74 49 1 bug
## 75 49 2 poison
## 76 50 1 ground
## 77 51 1 ground
## 78 52 1 normal
## 79 53 1 normal
## 80 54 1 water
## 81 55 1 water
## 82 56 1 fighting
## 83 57 1 fighting
## 84 58 1 fire
## 85 59 1 fire
## 86 60 1 water
## 87 61 1 water
## 88 62 1 water
## 89 62 2 fighting
## 90 63 1 psychic
## 91 64 1 psychic
## 92 65 1 psychic
## 93 66 1 fighting
## 94 67 1 fighting
## 95 68 1 fighting
## 96 69 1 grass
## 97 69 2 poison
## 98 70 1 grass
## 99 70 2 poison
## 100 71 1 grass
## 101 71 2 poison
## 102 72 1 water
## 103 72 2 poison
## 104 73 1 water
## 105 73 2 poison
## 106 74 1 rock
## 107 74 2 ground
## 108 75 1 rock
## 109 75 2 ground
## 110 76 1 rock
## 111 76 2 ground
## 112 77 1 fire
## 113 78 1 fire
## 114 79 1 water
## 115 79 2 psychic
## 116 80 1 water
## 117 80 2 psychic
## 118 81 1 electric
## 119 81 2 steel
## 120 82 1 electric
## 121 82 2 steel
## 122 83 1 normal
## 123 83 2 flying
## 124 84 1 normal
## 125 84 2 flying
## 126 85 1 normal
## 127 85 2 flying
## 128 86 1 water
## 129 87 1 water
## 130 87 2 ice
## 131 88 1 poison
## 132 89 1 poison
## 133 90 1 water
## 134 91 1 water
## 135 91 2 ice
## 136 92 1 ghost
## 137 92 2 poison
## 138 93 1 ghost
## 139 93 2 poison
## 140 94 1 ghost
## 141 94 2 poison
## 142 95 1 rock
## 143 95 2 ground
## 144 96 1 psychic
## 145 97 1 psychic
## 146 98 1 water
## 147 99 1 water
## 148 100 1 electric
## 149 101 1 electric
## 150 102 1 grass
## 151 102 2 psychic
## 152 103 1 grass
## 153 103 2 psychic
## 154 104 1 ground
## 155 105 1 ground
## 156 106 1 fighting
## 157 107 1 fighting
## 158 108 1 normal
## 159 109 1 poison
## 160 110 1 poison
## 161 111 1 ground
## 162 111 2 rock
## 163 112 1 ground
## 164 112 2 rock
## 165 113 1 normal
## 166 114 1 grass
## 167 115 1 normal
## 168 116 1 water
## 169 117 1 water
## 170 118 1 water
## 171 119 1 water
## 172 120 1 water
## 173 121 1 water
## 174 121 2 psychic
## 175 122 1 psychic
## 176 122 2 fairy
## 177 123 1 bug
## 178 123 2 flying
## 179 124 1 ice
## 180 124 2 psychic
## 181 125 1 electric
## 182 126 1 fire
## 183 127 1 bug
## 184 128 1 normal
## 185 129 1 water
## 186 130 1 water
## 187 130 2 flying
## 188 131 1 water
## 189 131 2 ice
## 190 132 1 normal
## 191 133 1 normal
## 192 134 1 water
## 193 135 1 electric
## 194 136 1 fire
## 195 137 1 normal
## 196 138 1 rock
## 197 138 2 water
## 198 139 1 rock
## 199 139 2 water
## 200 140 1 rock
## 201 140 2 water
## 202 141 1 rock
## 203 141 2 water
## 204 142 1 rock
## 205 142 2 flying
## 206 143 1 normal
## 207 144 1 ice
## 208 144 2 flying
## 209 145 1 electric
## 210 145 2 flying
## 211 146 1 fire
## 212 146 2 flying
## 213 147 1 dragon
## 214 148 1 dragon
## 215 149 1 dragon
## 216 149 2 flying
## 217 150 1 psychic
## 218 151 1 psychic
## 219 152 1 grass
## 220 153 1 grass
## 221 154 1 grass
## 222 155 1 fire
## 223 156 1 fire
## 224 157 1 fire
## 225 158 1 water
## 226 159 1 water
## 227 160 1 water
## 228 161 1 normal
## 229 162 1 normal
## 230 163 1 normal
## 231 163 2 flying
## 232 164 1 normal
## 233 164 2 flying
## 234 165 1 bug
## 235 165 2 flying
## 236 166 1 bug
## 237 166 2 flying
## 238 167 1 bug
## 239 167 2 poison
## 240 168 1 bug
## 241 168 2 poison
## 242 169 1 poison
## 243 169 2 flying
## 244 170 1 water
## 245 170 2 electric
## 246 171 1 water
## 247 171 2 electric
## 248 172 1 electric
## 249 173 1 fairy
## 250 174 1 normal
## 251 174 2 fairy
## 252 175 1 fairy
## 253 176 1 fairy
## 254 176 2 flying
## 255 177 1 psychic
## 256 177 2 flying
## 257 178 1 psychic
## 258 178 2 flying
## 259 179 1 electric
## 260 180 1 electric
## 261 181 1 electric
## 262 182 1 grass
## 263 183 1 water
## 264 183 2 fairy
## 265 184 1 water
## 266 184 2 fairy
## 267 185 1 rock
## 268 186 1 water
## 269 187 1 grass
## 270 187 2 flying
## 271 188 1 grass
## 272 188 2 flying
## 273 189 1 grass
## 274 189 2 flying
## 275 190 1 normal
## 276 191 1 grass
## 277 192 1 grass
## 278 193 1 bug
## 279 193 2 flying
## 280 194 1 water
## 281 194 2 ground
## 282 195 1 water
## 283 195 2 ground
## 284 196 1 psychic
## 285 197 1 dark
## 286 198 1 dark
## 287 198 2 flying
## 288 199 1 water
## 289 199 2 psychic
## 290 200 1 ghost
## 291 201 1 psychic
## 292 202 1 psychic
## 293 203 1 normal
## 294 203 2 psychic
## 295 204 1 bug
## 296 205 1 bug
## 297 205 2 steel
## 298 206 1 normal
## 299 207 1 ground
## 300 207 2 flying
## 301 208 1 steel
## 302 208 2 ground
## 303 209 1 fairy
## 304 210 1 fairy
## 305 211 1 water
## 306 211 2 poison
## 307 212 1 bug
## 308 212 2 steel
## 309 213 1 bug
## 310 213 2 rock
## 311 214 1 bug
## 312 214 2 fighting
## 313 215 1 dark
## 314 215 2 ice
## 315 216 1 normal
## 316 217 1 normal
## 317 218 1 fire
## 318 219 1 fire
## 319 219 2 rock
## 320 220 1 ice
## 321 220 2 ground
## 322 221 1 ice
## 323 221 2 ground
## 324 222 1 water
## 325 222 2 rock
## 326 223 1 water
## 327 224 1 water
## 328 225 1 ice
## 329 225 2 flying
## 330 226 1 water
## 331 226 2 flying
## 332 227 1 steel
## 333 227 2 flying
## 334 228 1 dark
## 335 228 2 fire
## 336 229 1 dark
## 337 229 2 fire
## 338 230 1 water
## 339 230 2 dragon
## 340 231 1 ground
## 341 232 1 ground
## 342 233 1 normal
## 343 234 1 normal
## 344 235 1 normal
## 345 236 1 fighting
## 346 237 1 fighting
## 347 238 1 ice
## 348 238 2 psychic
## 349 239 1 electric
## 350 240 1 fire
## 351 241 1 normal
## 352 242 1 normal
## 353 243 1 electric
## 354 244 1 fire
## 355 245 1 water
## 356 246 1 rock
## 357 246 2 ground
## 358 247 1 rock
## 359 247 2 ground
## 360 248 1 rock
## 361 248 2 dark
## 362 249 1 psychic
## 363 249 2 flying
## 364 250 1 fire
## 365 250 2 flying
## 366 251 1 psychic
## 367 251 2 grass
## 368 252 1 grass
## 369 253 1 grass
## 370 254 1 grass
## 371 255 1 fire
## 372 256 1 fire
## 373 256 2 fighting
## 374 257 1 fire
## 375 257 2 fighting
## 376 258 1 water
## 377 259 1 water
## 378 259 2 ground
## 379 260 1 water
## 380 260 2 ground
## 381 261 1 dark
## 382 262 1 dark
## 383 263 1 normal
## 384 264 1 normal
## 385 265 1 bug
## 386 266 1 bug
## 387 267 1 bug
## 388 267 2 flying
## 389 268 1 bug
## 390 269 1 bug
## 391 269 2 poison
## 392 270 1 water
## 393 270 2 grass
## 394 271 1 water
## 395 271 2 grass
## 396 272 1 water
## 397 272 2 grass
## 398 273 1 grass
## 399 274 1 grass
## 400 274 2 dark
## 401 275 1 grass
## 402 275 2 dark
## 403 276 1 normal
## 404 276 2 flying
## 405 277 1 normal
## 406 277 2 flying
## 407 278 1 water
## 408 278 2 flying
## 409 279 1 water
## 410 279 2 flying
## 411 280 1 psychic
## 412 280 2 fairy
## 413 281 1 psychic
## 414 281 2 fairy
## 415 282 1 psychic
## 416 282 2 fairy
## 417 283 1 bug
## 418 283 2 water
## 419 284 1 bug
## 420 284 2 flying
## 421 285 1 grass
## 422 286 1 grass
## 423 286 2 fighting
## 424 287 1 normal
## 425 288 1 normal
## 426 289 1 normal
## 427 290 1 bug
## 428 290 2 ground
## 429 291 1 bug
## 430 291 2 flying
## 431 292 1 bug
## 432 292 2 ghost
## 433 293 1 normal
## 434 294 1 normal
## 435 295 1 normal
## 436 296 1 fighting
## 437 297 1 fighting
## 438 298 1 normal
## 439 298 2 fairy
## 440 299 1 rock
## 441 300 1 normal
## 442 301 1 normal
## 443 302 1 dark
## 444 302 2 ghost
## 445 303 1 steel
## 446 303 2 fairy
## 447 304 1 steel
## 448 304 2 rock
## 449 305 1 steel
## 450 305 2 rock
## 451 306 1 steel
## 452 306 2 rock
## 453 307 1 fighting
## 454 307 2 psychic
## 455 308 1 fighting
## 456 308 2 psychic
## 457 309 1 electric
## 458 310 1 electric
## 459 311 1 electric
## 460 312 1 electric
## 461 313 1 bug
## 462 314 1 bug
## 463 315 1 grass
## 464 315 2 poison
## 465 316 1 poison
## 466 317 1 poison
## 467 318 1 water
## 468 318 2 dark
## 469 319 1 water
## 470 319 2 dark
## 471 320 1 water
## 472 321 1 water
## 473 322 1 fire
## 474 322 2 ground
## 475 323 1 fire
## 476 323 2 ground
## 477 324 1 fire
## 478 325 1 psychic
## 479 326 1 psychic
## 480 327 1 normal
## 481 328 1 ground
## 482 329 1 ground
## 483 329 2 dragon
## 484 330 1 ground
## 485 330 2 dragon
## 486 331 1 grass
## 487 332 1 grass
## 488 332 2 dark
## 489 333 1 normal
## 490 333 2 flying
## 491 334 1 dragon
## 492 334 2 flying
## 493 335 1 normal
## 494 336 1 poison
## 495 337 1 rock
## 496 337 2 psychic
## 497 338 1 rock
## 498 338 2 psychic
## 499 339 1 water
## 500 339 2 ground
## 501 340 1 water
## 502 340 2 ground
## 503 341 1 water
## 504 342 1 water
## 505 342 2 dark
## 506 343 1 ground
## 507 343 2 psychic
## 508 344 1 ground
## 509 344 2 psychic
## 510 345 1 rock
## 511 345 2 grass
## 512 346 1 rock
## 513 346 2 grass
## 514 347 1 rock
## 515 347 2 bug
## 516 348 1 rock
## 517 348 2 bug
## 518 349 1 water
## 519 350 1 water
## 520 351 1 normal
## 521 352 1 normal
## 522 353 1 ghost
## 523 354 1 ghost
## 524 355 1 ghost
## 525 356 1 ghost
## 526 357 1 grass
## 527 357 2 flying
## 528 358 1 psychic
## 529 359 1 dark
## 530 360 1 psychic
## 531 361 1 ice
## 532 362 1 ice
## 533 363 1 ice
## 534 363 2 water
## 535 364 1 ice
## 536 364 2 water
## 537 365 1 ice
## 538 365 2 water
## 539 366 1 water
## 540 367 1 water
## 541 368 1 water
## 542 369 1 water
## 543 369 2 rock
## 544 370 1 water
## 545 371 1 dragon
## 546 372 1 dragon
## 547 373 1 dragon
## 548 373 2 flying
## 549 374 1 steel
## 550 374 2 psychic
## 551 375 1 steel
## 552 375 2 psychic
## 553 376 1 steel
## 554 376 2 psychic
## 555 377 1 rock
## 556 378 1 ice
## 557 379 1 steel
## 558 380 1 dragon
## 559 380 2 psychic
## 560 381 1 dragon
## 561 381 2 psychic
## 562 382 1 water
## 563 383 1 ground
## 564 384 1 dragon
## 565 384 2 flying
## 566 385 1 steel
## 567 385 2 psychic
## 568 386 1 psychic
## 569 387 1 grass
## 570 388 1 grass
## 571 389 1 grass
## 572 389 2 ground
## 573 390 1 fire
## 574 391 1 fire
## 575 391 2 fighting
## 576 392 1 fire
## 577 392 2 fighting
## 578 393 1 water
## 579 394 1 water
## 580 395 1 water
## 581 395 2 steel
## 582 396 1 normal
## 583 396 2 flying
## 584 397 1 normal
## 585 397 2 flying
## 586 398 1 normal
## 587 398 2 flying
## 588 399 1 normal
## 589 400 1 normal
## 590 400 2 water
## 591 401 1 bug
## 592 402 1 bug
## 593 403 1 electric
## 594 404 1 electric
## 595 405 1 electric
## 596 406 1 grass
## 597 406 2 poison
## 598 407 1 grass
## 599 407 2 poison
## 600 408 1 rock
## 601 409 1 rock
## 602 410 1 rock
## 603 410 2 steel
## 604 411 1 rock
## 605 411 2 steel
## 606 412 1 bug
## 607 413 1 bug
## 608 413 2 grass
## 609 414 1 bug
## 610 414 2 flying
## 611 415 1 bug
## 612 415 2 flying
## 613 416 1 bug
## 614 416 2 flying
## 615 417 1 electric
## 616 418 1 water
## 617 419 1 water
## 618 420 1 grass
## 619 421 1 grass
## 620 422 1 water
## 621 423 1 water
## 622 423 2 ground
## 623 424 1 normal
## 624 425 1 ghost
## 625 425 2 flying
## 626 426 1 ghost
## 627 426 2 flying
## 628 427 1 normal
## 629 428 1 normal
## 630 429 1 ghost
## 631 430 1 dark
## 632 430 2 flying
## 633 431 1 normal
## 634 432 1 normal
## 635 433 1 psychic
## 636 434 1 poison
## 637 434 2 dark
## 638 435 1 poison
## 639 435 2 dark
## 640 436 1 steel
## 641 436 2 psychic
## 642 437 1 steel
## 643 437 2 psychic
## 644 438 1 rock
## 645 439 1 psychic
## 646 439 2 fairy
## 647 440 1 normal
## 648 441 1 normal
## 649 441 2 flying
## 650 442 1 ghost
## 651 442 2 dark
## 652 443 1 dragon
## 653 443 2 ground
## 654 444 1 dragon
## 655 444 2 ground
## 656 445 1 dragon
## 657 445 2 ground
## 658 446 1 normal
## 659 447 1 fighting
## 660 448 1 fighting
## 661 448 2 steel
## 662 449 1 ground
## 663 450 1 ground
## 664 451 1 poison
## 665 451 2 bug
## 666 452 1 poison
## 667 452 2 dark
## 668 453 1 poison
## 669 453 2 fighting
## 670 454 1 poison
## 671 454 2 fighting
## 672 455 1 grass
## 673 456 1 water
## 674 457 1 water
## 675 458 1 water
## 676 458 2 flying
## 677 459 1 grass
## 678 459 2 ice
## 679 460 1 grass
## 680 460 2 ice
## 681 461 1 dark
## 682 461 2 ice
## 683 462 1 electric
## 684 462 2 steel
## 685 463 1 normal
## 686 464 1 ground
## 687 464 2 rock
## 688 465 1 grass
## 689 466 1 electric
## 690 467 1 fire
## 691 468 1 fairy
## 692 468 2 flying
## 693 469 1 bug
## 694 469 2 flying
## 695 470 1 grass
## 696 471 1 ice
## 697 472 1 ground
## 698 472 2 flying
## 699 473 1 ice
## 700 473 2 ground
## 701 474 1 normal
## 702 475 1 psychic
## 703 475 2 fighting
## 704 476 1 rock
## 705 476 2 steel
## 706 477 1 ghost
## 707 478 1 ice
## 708 478 2 ghost
## 709 479 1 electric
## 710 479 2 ghost
## 711 480 1 psychic
## 712 481 1 psychic
## 713 482 1 psychic
## 714 483 1 steel
## 715 483 2 dragon
## 716 484 1 water
## 717 484 2 dragon
## 718 485 1 fire
## 719 485 2 steel
## 720 486 1 normal
## 721 487 1 ghost
## 722 487 2 dragon
## 723 488 1 psychic
## 724 489 1 water
## 725 490 1 water
## 726 491 1 dark
## 727 492 1 grass
## 728 493 1 normal
## 729 494 1 psychic
## 730 494 2 fire
## 731 495 1 grass
## 732 496 1 grass
## 733 497 1 grass
## 734 498 1 fire
## 735 499 1 fire
## 736 499 2 fighting
## 737 500 1 fire
## 738 500 2 fighting
## 739 501 1 water
## 740 502 1 water
## 741 503 1 water
## 742 504 1 normal
## 743 505 1 normal
## 744 506 1 normal
## 745 507 1 normal
## 746 508 1 normal
## 747 509 1 dark
## 748 510 1 dark
## 749 511 1 grass
## 750 512 1 grass
## 751 513 1 fire
## 752 514 1 fire
## 753 515 1 water
## 754 516 1 water
## 755 517 1 psychic
## 756 518 1 psychic
## 757 519 1 normal
## 758 519 2 flying
## 759 520 1 normal
## 760 520 2 flying
## 761 521 1 normal
## 762 521 2 flying
## 763 522 1 electric
## 764 523 1 electric
## 765 524 1 rock
## 766 525 1 rock
## 767 526 1 rock
## 768 527 1 psychic
## 769 527 2 flying
## 770 528 1 psychic
## 771 528 2 flying
## 772 529 1 ground
## 773 530 1 ground
## 774 530 2 steel
## 775 531 1 normal
## 776 532 1 fighting
## 777 533 1 fighting
## 778 534 1 fighting
## 779 535 1 water
## 780 536 1 water
## 781 536 2 ground
## 782 537 1 water
## 783 537 2 ground
## 784 538 1 fighting
## 785 539 1 fighting
## 786 540 1 bug
## 787 540 2 grass
## 788 541 1 bug
## 789 541 2 grass
## 790 542 1 bug
## 791 542 2 grass
## 792 543 1 bug
## 793 543 2 poison
## 794 544 1 bug
## 795 544 2 poison
## 796 545 1 bug
## 797 545 2 poison
## 798 546 1 grass
## 799 546 2 fairy
## 800 547 1 grass
## 801 547 2 fairy
## 802 548 1 grass
## 803 549 1 grass
## 804 550 1 water
## 805 551 1 ground
## 806 551 2 dark
## 807 552 1 ground
## 808 552 2 dark
## 809 553 1 ground
## 810 553 2 dark
## 811 554 1 fire
## 812 555 1 fire
## 813 556 1 grass
## 814 557 1 bug
## 815 557 2 rock
## 816 558 1 bug
## 817 558 2 rock
## 818 559 1 dark
## 819 559 2 fighting
## 820 560 1 dark
## 821 560 2 fighting
## 822 561 1 psychic
## 823 561 2 flying
## 824 562 1 ghost
## 825 563 1 ghost
## 826 564 1 water
## 827 564 2 rock
## 828 565 1 water
## 829 565 2 rock
## 830 566 1 rock
## 831 566 2 flying
## 832 567 1 rock
## 833 567 2 flying
## 834 568 1 poison
## 835 569 1 poison
## 836 570 1 dark
## 837 571 1 dark
## 838 572 1 normal
## 839 573 1 normal
## 840 574 1 psychic
## 841 575 1 psychic
## 842 576 1 psychic
## 843 577 1 psychic
## 844 578 1 psychic
## 845 579 1 psychic
## 846 580 1 water
## 847 580 2 flying
## 848 581 1 water
## 849 581 2 flying
## 850 582 1 ice
## 851 583 1 ice
## 852 584 1 ice
## 853 585 1 normal
## 854 585 2 grass
## 855 586 1 normal
## 856 586 2 grass
## 857 587 1 electric
## 858 587 2 flying
## 859 588 1 bug
## 860 589 1 bug
## 861 589 2 steel
## 862 590 1 grass
## 863 590 2 poison
## 864 591 1 grass
## 865 591 2 poison
## 866 592 1 water
## 867 592 2 ghost
## 868 593 1 water
## 869 593 2 ghost
## 870 594 1 water
## 871 595 1 bug
## 872 595 2 electric
## 873 596 1 bug
## 874 596 2 electric
## 875 597 1 grass
## 876 597 2 steel
## 877 598 1 grass
## 878 598 2 steel
## 879 599 1 steel
## 880 600 1 steel
## 881 601 1 steel
## 882 602 1 electric
## 883 603 1 electric
## 884 604 1 electric
## 885 605 1 psychic
## 886 606 1 psychic
## 887 607 1 ghost
## 888 607 2 fire
## 889 608 1 ghost
## 890 608 2 fire
## 891 609 1 ghost
## 892 609 2 fire
## 893 610 1 dragon
## 894 611 1 dragon
## 895 612 1 dragon
## 896 613 1 ice
## 897 614 1 ice
## 898 615 1 ice
## 899 616 1 bug
## 900 617 1 bug
## 901 618 1 ground
## 902 618 2 electric
## 903 619 1 fighting
## 904 620 1 fighting
## 905 621 1 dragon
## 906 622 1 ground
## 907 622 2 ghost
## 908 623 1 ground
## 909 623 2 ghost
## 910 624 1 dark
## 911 624 2 steel
## 912 625 1 dark
## 913 625 2 steel
## 914 626 1 normal
## 915 627 1 normal
## 916 627 2 flying
## 917 628 1 normal
## 918 628 2 flying
## 919 629 1 dark
## 920 629 2 flying
## 921 630 1 dark
## 922 630 2 flying
## 923 631 1 fire
## 924 632 1 bug
## 925 632 2 steel
## 926 633 1 dark
## 927 633 2 dragon
## 928 634 1 dark
## 929 634 2 dragon
## 930 635 1 dark
## 931 635 2 dragon
## 932 636 1 bug
## 933 636 2 fire
## 934 637 1 bug
## 935 637 2 fire
## 936 638 1 steel
## 937 638 2 fighting
## 938 639 1 rock
## 939 639 2 fighting
## 940 640 1 grass
## 941 640 2 fighting
## 942 641 1 flying
## 943 642 1 electric
## 944 642 2 flying
## 945 643 1 dragon
## 946 643 2 fire
## 947 644 1 dragon
## 948 644 2 electric
## 949 645 1 ground
## 950 645 2 flying
## 951 646 1 dragon
## 952 646 2 ice
## 953 647 1 water
## 954 647 2 fighting
## 955 648 1 normal
## 956 648 2 psychic
## 957 649 1 bug
## 958 649 2 steel
## 959 650 1 grass
## 960 651 1 grass
## 961 652 1 grass
## 962 652 2 fighting
## 963 653 1 fire
## 964 654 1 fire
## 965 655 1 fire
## 966 655 2 psychic
## 967 656 1 water
## 968 657 1 water
## 969 658 1 water
## 970 658 2 dark
## 971 659 1 normal
## 972 660 1 normal
## 973 660 2 ground
## 974 661 1 normal
## 975 661 2 flying
## 976 662 1 fire
## 977 662 2 flying
## 978 663 1 fire
## 979 663 2 flying
## 980 664 1 bug
## 981 665 1 bug
## 982 666 1 bug
## 983 666 2 flying
## 984 667 1 fire
## 985 667 2 normal
## 986 668 1 fire
## 987 668 2 normal
## 988 669 1 fairy
## 989 670 1 fairy
## 990 671 1 fairy
## 991 672 1 grass
## 992 673 1 grass
## 993 674 1 fighting
## 994 675 1 fighting
## 995 675 2 dark
## 996 676 1 normal
## 997 677 1 psychic
## 998 678 1 psychic
## 999 679 1 steel
## 1000 679 2 ghost
## 1001 680 1 steel
## 1002 680 2 ghost
## 1003 681 1 steel
## 1004 681 2 ghost
## 1005 682 1 fairy
## 1006 683 1 fairy
## 1007 684 1 fairy
## 1008 685 1 fairy
## 1009 686 1 dark
## 1010 686 2 psychic
## 1011 687 1 dark
## 1012 687 2 psychic
## 1013 688 1 rock
## 1014 688 2 water
## 1015 689 1 rock
## 1016 689 2 water
## 1017 690 1 poison
## 1018 690 2 water
## 1019 691 1 poison
## 1020 691 2 dragon
## 1021 692 1 water
## 1022 693 1 water
## 1023 694 1 electric
## 1024 694 2 normal
## 1025 695 1 electric
## 1026 695 2 normal
## 1027 696 1 rock
## 1028 696 2 dragon
## 1029 697 1 rock
## 1030 697 2 dragon
## 1031 698 1 rock
## 1032 698 2 ice
## 1033 699 1 rock
## 1034 699 2 ice
## 1035 700 1 fairy
## 1036 701 1 fighting
## 1037 701 2 flying
## 1038 702 1 electric
## 1039 702 2 fairy
## 1040 703 1 rock
## 1041 703 2 fairy
## 1042 704 1 dragon
## 1043 705 1 dragon
## 1044 706 1 dragon
## 1045 707 1 steel
## 1046 707 2 fairy
## 1047 708 1 ghost
## 1048 708 2 grass
## 1049 709 1 ghost
## 1050 709 2 grass
## 1051 710 1 ghost
## 1052 710 2 grass
## 1053 711 1 ghost
## 1054 711 2 grass
## 1055 712 1 ice
## 1056 713 1 ice
## 1057 714 1 flying
## 1058 714 2 dragon
## 1059 715 1 flying
## 1060 715 2 dragon
## 1061 716 1 fairy
## 1062 717 1 dark
## 1063 717 2 flying
## 1064 718 1 dragon
## 1065 718 2 ground
## 1066 719 1 rock
## 1067 719 2 fairy
## 1068 720 1 psychic
## 1069 720 2 ghost
## 1070 721 1 fire
## 1071 721 2 water
## 1072 10001 1 psychic
## 1073 10002 1 psychic
## 1074 10003 1 psychic
## 1075 10004 1 bug
## 1076 10004 2 ground
## 1077 10005 1 bug
## 1078 10005 2 steel
## 1079 10006 1 grass
## 1080 10006 2 flying
## 1081 10007 1 ghost
## 1082 10007 2 dragon
## 1083 10008 1 electric
## 1084 10008 2 fire
## 1085 10009 1 electric
## 1086 10009 2 water
## 1087 10010 1 electric
## 1088 10010 2 ice
## 1089 10011 1 electric
## 1090 10011 2 flying
## 1091 10012 1 electric
## 1092 10012 2 grass
## 1093 10013 1 fire
## 1094 10014 1 water
## 1095 10015 1 ice
## 1096 10016 1 water
## 1097 10017 1 fire
## 1098 10017 2 psychic
## 1099 10018 1 normal
## 1100 10018 2 fighting
## 1101 10019 1 flying
## 1102 10020 1 electric
## 1103 10020 2 flying
## 1104 10021 1 ground
## 1105 10021 2 flying
## 1106 10022 1 dragon
## 1107 10022 2 ice
## 1108 10023 1 dragon
## 1109 10023 2 ice
## 1110 10024 1 water
## 1111 10024 2 fighting
## 1112 10025 1 psychic
## 1113 10026 1 steel
## 1114 10026 2 ghost
## 1115 10027 1 ghost
## 1116 10027 2 grass
## 1117 10028 1 ghost
## 1118 10028 2 grass
## 1119 10029 1 ghost
## 1120 10029 2 grass
## 1121 10030 1 ghost
## 1122 10030 2 grass
## 1123 10031 1 ghost
## 1124 10031 2 grass
## 1125 10032 1 ghost
## 1126 10032 2 grass
## 1127 10033 1 grass
## 1128 10033 2 poison
## 1129 10034 1 fire
## 1130 10034 2 dragon
## 1131 10035 1 fire
## 1132 10035 2 flying
## 1133 10036 1 water
## 1134 10037 1 psychic
## 1135 10038 1 ghost
## 1136 10038 2 poison
## 1137 10039 1 normal
## 1138 10040 1 bug
## 1139 10040 2 flying
## 1140 10041 1 water
## 1141 10041 2 dark
## 1142 10042 1 rock
## 1143 10042 2 flying
## 1144 10043 1 psychic
## 1145 10043 2 fighting
## 1146 10044 1 psychic
## 1147 10045 1 electric
## 1148 10045 2 dragon
## 1149 10046 1 bug
## 1150 10046 2 steel
## 1151 10047 1 bug
## 1152 10047 2 fighting
## 1153 10048 1 dark
## 1154 10048 2 fire
## 1155 10049 1 rock
## 1156 10049 2 dark
## 1157 10050 1 fire
## 1158 10050 2 fighting
## 1159 10051 1 psychic
## 1160 10051 2 fairy
## 1161 10052 1 steel
## 1162 10052 2 fairy
## 1163 10053 1 steel
## 1164 10054 1 fighting
## 1165 10054 2 psychic
## 1166 10055 1 electric
## 1167 10056 1 ghost
## 1168 10057 1 dark
## 1169 10058 1 dragon
## 1170 10058 2 ground
## 1171 10059 1 fighting
## 1172 10059 2 steel
## 1173 10060 1 grass
## 1174 10060 2 ice
## 1175 10061 1 fairy
## 1176 10062 1 dragon
## 1177 10062 2 psychic
## 1178 10063 1 dragon
## 1179 10063 2 psychic
## 1180 10064 1 water
## 1181 10064 2 ground
## 1182 10065 1 grass
## 1183 10065 2 dragon
## 1184 10066 1 dark
## 1185 10066 2 ghost
## 1186 10067 1 dragon
## 1187 10067 2 fairy
## 1188 10068 1 psychic
## 1189 10068 2 fighting
## 1190 10069 1 normal
## 1191 10069 2 fairy
## 1192 10070 1 water
## 1193 10070 2 dark
## 1194 10071 1 water
## 1195 10071 2 psychic
## 1196 10072 1 steel
## 1197 10072 2 ground
## 1198 10073 1 normal
## 1199 10073 2 flying
## 1200 10074 1 ice
## 1201 10075 1 rock
## 1202 10075 2 fairy
## 1203 10076 1 steel
## 1204 10076 2 psychic
## 1205 10077 1 water
## 1206 10078 1 ground
## 1207 10078 2 fire
## 1208 10079 1 dragon
## 1209 10079 2 flying
## 1210 10080 1 electric
## 1211 10081 1 electric
## 1212 10082 1 electric
## 1213 10083 1 electric
## 1214 10084 1 electric
## 1215 10085 1 electric
## 1216 10086 1 psychic
## 1217 10086 2 dark
## 1218 10087 1 fire
## 1219 10087 2 ground
## 1220 10088 1 normal
## 1221 10088 2 fighting
## 1222 10089 1 dragon
## 1223 10089 2 flying
## 1224 10090 1 bug
## 1225 10090 2 poison
NOTE: Join pokemon_types and types. pokemon_types gives pokemon id and their type id for slot 1 and 2. types gives the type names that correlate with the type id.
dbGetQuery(pokemonDatabase, "
SELECT *
FROM pokemon_types")
## pokemon_id type_id slot
## 1 1 12 1
## 2 1 4 2
## 3 2 12 1
## 4 2 4 2
## 5 3 12 1
## 6 3 4 2
## 7 4 10 1
## 8 5 10 1
## 9 6 10 1
## 10 6 3 2
## 11 7 11 1
## 12 8 11 1
## 13 9 11 1
## 14 10 7 1
## 15 11 7 1
## 16 12 7 1
## 17 12 3 2
## 18 13 7 1
## 19 13 4 2
## 20 14 7 1
## 21 14 4 2
## 22 15 7 1
## 23 15 4 2
## 24 16 1 1
## 25 16 3 2
## 26 17 1 1
## 27 17 3 2
## 28 18 1 1
## 29 18 3 2
## 30 19 1 1
## 31 20 1 1
## 32 21 1 1
## 33 21 3 2
## 34 22 1 1
## 35 22 3 2
## 36 23 4 1
## 37 24 4 1
## 38 25 13 1
## 39 26 13 1
## 40 27 5 1
## 41 28 5 1
## 42 29 4 1
## 43 30 4 1
## 44 31 4 1
## 45 31 5 2
## 46 32 4 1
## 47 33 4 1
## 48 34 4 1
## 49 34 5 2
## 50 35 18 1
## 51 36 18 1
## 52 37 10 1
## 53 38 10 1
## 54 39 1 1
## 55 39 18 2
## 56 40 1 1
## 57 40 18 2
## 58 41 4 1
## 59 41 3 2
## 60 42 4 1
## 61 42 3 2
## 62 43 12 1
## 63 43 4 2
## 64 44 12 1
## 65 44 4 2
## 66 45 12 1
## 67 45 4 2
## 68 46 7 1
## 69 46 12 2
## 70 47 7 1
## 71 47 12 2
## 72 48 7 1
## 73 48 4 2
## 74 49 7 1
## 75 49 4 2
## 76 50 5 1
## 77 51 5 1
## 78 52 1 1
## 79 53 1 1
## 80 54 11 1
## 81 55 11 1
## 82 56 2 1
## 83 57 2 1
## 84 58 10 1
## 85 59 10 1
## 86 60 11 1
## 87 61 11 1
## 88 62 11 1
## 89 62 2 2
## 90 63 14 1
## 91 64 14 1
## 92 65 14 1
## 93 66 2 1
## 94 67 2 1
## 95 68 2 1
## 96 69 12 1
## 97 69 4 2
## 98 70 12 1
## 99 70 4 2
## 100 71 12 1
## 101 71 4 2
## 102 72 11 1
## 103 72 4 2
## 104 73 11 1
## 105 73 4 2
## 106 74 6 1
## 107 74 5 2
## 108 75 6 1
## 109 75 5 2
## 110 76 6 1
## 111 76 5 2
## 112 77 10 1
## 113 78 10 1
## 114 79 11 1
## 115 79 14 2
## 116 80 11 1
## 117 80 14 2
## 118 81 13 1
## 119 81 9 2
## 120 82 13 1
## 121 82 9 2
## 122 83 1 1
## 123 83 3 2
## 124 84 1 1
## 125 84 3 2
## 126 85 1 1
## 127 85 3 2
## 128 86 11 1
## 129 87 11 1
## 130 87 15 2
## 131 88 4 1
## 132 89 4 1
## 133 90 11 1
## 134 91 11 1
## 135 91 15 2
## 136 92 8 1
## 137 92 4 2
## 138 93 8 1
## 139 93 4 2
## 140 94 8 1
## 141 94 4 2
## 142 95 6 1
## 143 95 5 2
## 144 96 14 1
## 145 97 14 1
## 146 98 11 1
## 147 99 11 1
## 148 100 13 1
## 149 101 13 1
## 150 102 12 1
## 151 102 14 2
## 152 103 12 1
## 153 103 14 2
## 154 104 5 1
## 155 105 5 1
## 156 106 2 1
## 157 107 2 1
## 158 108 1 1
## 159 109 4 1
## 160 110 4 1
## 161 111 5 1
## 162 111 6 2
## 163 112 5 1
## 164 112 6 2
## 165 113 1 1
## 166 114 12 1
## 167 115 1 1
## 168 116 11 1
## 169 117 11 1
## 170 118 11 1
## 171 119 11 1
## 172 120 11 1
## 173 121 11 1
## 174 121 14 2
## 175 122 14 1
## 176 122 18 2
## 177 123 7 1
## 178 123 3 2
## 179 124 15 1
## 180 124 14 2
## 181 125 13 1
## 182 126 10 1
## 183 127 7 1
## 184 128 1 1
## 185 129 11 1
## 186 130 11 1
## 187 130 3 2
## 188 131 11 1
## 189 131 15 2
## 190 132 1 1
## 191 133 1 1
## 192 134 11 1
## 193 135 13 1
## 194 136 10 1
## 195 137 1 1
## 196 138 6 1
## 197 138 11 2
## 198 139 6 1
## 199 139 11 2
## 200 140 6 1
## 201 140 11 2
## 202 141 6 1
## 203 141 11 2
## 204 142 6 1
## 205 142 3 2
## 206 143 1 1
## 207 144 15 1
## 208 144 3 2
## 209 145 13 1
## 210 145 3 2
## 211 146 10 1
## 212 146 3 2
## 213 147 16 1
## 214 148 16 1
## 215 149 16 1
## 216 149 3 2
## 217 150 14 1
## 218 151 14 1
## 219 152 12 1
## 220 153 12 1
## 221 154 12 1
## 222 155 10 1
## 223 156 10 1
## 224 157 10 1
## 225 158 11 1
## 226 159 11 1
## 227 160 11 1
## 228 161 1 1
## 229 162 1 1
## 230 163 1 1
## 231 163 3 2
## 232 164 1 1
## 233 164 3 2
## 234 165 7 1
## 235 165 3 2
## 236 166 7 1
## 237 166 3 2
## 238 167 7 1
## 239 167 4 2
## 240 168 7 1
## 241 168 4 2
## 242 169 4 1
## 243 169 3 2
## 244 170 11 1
## 245 170 13 2
## 246 171 11 1
## 247 171 13 2
## 248 172 13 1
## 249 173 18 1
## 250 174 1 1
## 251 174 18 2
## 252 175 18 1
## 253 176 18 1
## 254 176 3 2
## 255 177 14 1
## 256 177 3 2
## 257 178 14 1
## 258 178 3 2
## 259 179 13 1
## 260 180 13 1
## 261 181 13 1
## 262 182 12 1
## 263 183 11 1
## 264 183 18 2
## 265 184 11 1
## 266 184 18 2
## 267 185 6 1
## 268 186 11 1
## 269 187 12 1
## 270 187 3 2
## 271 188 12 1
## 272 188 3 2
## 273 189 12 1
## 274 189 3 2
## 275 190 1 1
## 276 191 12 1
## 277 192 12 1
## 278 193 7 1
## 279 193 3 2
## 280 194 11 1
## 281 194 5 2
## 282 195 11 1
## 283 195 5 2
## 284 196 14 1
## 285 197 17 1
## 286 198 17 1
## 287 198 3 2
## 288 199 11 1
## 289 199 14 2
## 290 200 8 1
## 291 201 14 1
## 292 202 14 1
## 293 203 1 1
## 294 203 14 2
## 295 204 7 1
## 296 205 7 1
## 297 205 9 2
## 298 206 1 1
## 299 207 5 1
## 300 207 3 2
## 301 208 9 1
## 302 208 5 2
## 303 209 18 1
## 304 210 18 1
## 305 211 11 1
## 306 211 4 2
## 307 212 7 1
## 308 212 9 2
## 309 213 7 1
## 310 213 6 2
## 311 214 7 1
## 312 214 2 2
## 313 215 17 1
## 314 215 15 2
## 315 216 1 1
## 316 217 1 1
## 317 218 10 1
## 318 219 10 1
## 319 219 6 2
## 320 220 15 1
## 321 220 5 2
## 322 221 15 1
## 323 221 5 2
## 324 222 11 1
## 325 222 6 2
## 326 223 11 1
## 327 224 11 1
## 328 225 15 1
## 329 225 3 2
## 330 226 11 1
## 331 226 3 2
## 332 227 9 1
## 333 227 3 2
## 334 228 17 1
## 335 228 10 2
## 336 229 17 1
## 337 229 10 2
## 338 230 11 1
## 339 230 16 2
## 340 231 5 1
## 341 232 5 1
## 342 233 1 1
## 343 234 1 1
## 344 235 1 1
## 345 236 2 1
## 346 237 2 1
## 347 238 15 1
## 348 238 14 2
## 349 239 13 1
## 350 240 10 1
## 351 241 1 1
## 352 242 1 1
## 353 243 13 1
## 354 244 10 1
## 355 245 11 1
## 356 246 6 1
## 357 246 5 2
## 358 247 6 1
## 359 247 5 2
## 360 248 6 1
## 361 248 17 2
## 362 249 14 1
## 363 249 3 2
## 364 250 10 1
## 365 250 3 2
## 366 251 14 1
## 367 251 12 2
## 368 252 12 1
## 369 253 12 1
## 370 254 12 1
## 371 255 10 1
## 372 256 10 1
## 373 256 2 2
## 374 257 10 1
## 375 257 2 2
## 376 258 11 1
## 377 259 11 1
## 378 259 5 2
## 379 260 11 1
## 380 260 5 2
## 381 261 17 1
## 382 262 17 1
## 383 263 1 1
## 384 264 1 1
## 385 265 7 1
## 386 266 7 1
## 387 267 7 1
## 388 267 3 2
## 389 268 7 1
## 390 269 7 1
## 391 269 4 2
## 392 270 11 1
## 393 270 12 2
## 394 271 11 1
## 395 271 12 2
## 396 272 11 1
## 397 272 12 2
## 398 273 12 1
## 399 274 12 1
## 400 274 17 2
## 401 275 12 1
## 402 275 17 2
## 403 276 1 1
## 404 276 3 2
## 405 277 1 1
## 406 277 3 2
## 407 278 11 1
## 408 278 3 2
## 409 279 11 1
## 410 279 3 2
## 411 280 14 1
## 412 280 18 2
## 413 281 14 1
## 414 281 18 2
## 415 282 14 1
## 416 282 18 2
## 417 283 7 1
## 418 283 11 2
## 419 284 7 1
## 420 284 3 2
## 421 285 12 1
## 422 286 12 1
## 423 286 2 2
## 424 287 1 1
## 425 288 1 1
## 426 289 1 1
## 427 290 7 1
## 428 290 5 2
## 429 291 7 1
## 430 291 3 2
## 431 292 7 1
## 432 292 8 2
## 433 293 1 1
## 434 294 1 1
## 435 295 1 1
## 436 296 2 1
## 437 297 2 1
## 438 298 1 1
## 439 298 18 2
## 440 299 6 1
## 441 300 1 1
## 442 301 1 1
## 443 302 17 1
## 444 302 8 2
## 445 303 9 1
## 446 303 18 2
## 447 304 9 1
## 448 304 6 2
## 449 305 9 1
## 450 305 6 2
## 451 306 9 1
## 452 306 6 2
## 453 307 2 1
## 454 307 14 2
## 455 308 2 1
## 456 308 14 2
## 457 309 13 1
## 458 310 13 1
## 459 311 13 1
## 460 312 13 1
## 461 313 7 1
## 462 314 7 1
## 463 315 12 1
## 464 315 4 2
## 465 316 4 1
## 466 317 4 1
## 467 318 11 1
## 468 318 17 2
## 469 319 11 1
## 470 319 17 2
## 471 320 11 1
## 472 321 11 1
## 473 322 10 1
## 474 322 5 2
## 475 323 10 1
## 476 323 5 2
## 477 324 10 1
## 478 325 14 1
## 479 326 14 1
## 480 327 1 1
## 481 328 5 1
## 482 329 5 1
## 483 329 16 2
## 484 330 5 1
## 485 330 16 2
## 486 331 12 1
## 487 332 12 1
## 488 332 17 2
## 489 333 1 1
## 490 333 3 2
## 491 334 16 1
## 492 334 3 2
## 493 335 1 1
## 494 336 4 1
## 495 337 6 1
## 496 337 14 2
## 497 338 6 1
## 498 338 14 2
## 499 339 11 1
## 500 339 5 2
## 501 340 11 1
## 502 340 5 2
## 503 341 11 1
## 504 342 11 1
## 505 342 17 2
## 506 343 5 1
## 507 343 14 2
## 508 344 5 1
## 509 344 14 2
## 510 345 6 1
## 511 345 12 2
## 512 346 6 1
## 513 346 12 2
## 514 347 6 1
## 515 347 7 2
## 516 348 6 1
## 517 348 7 2
## 518 349 11 1
## 519 350 11 1
## 520 351 1 1
## 521 352 1 1
## 522 353 8 1
## 523 354 8 1
## 524 355 8 1
## 525 356 8 1
## 526 357 12 1
## 527 357 3 2
## 528 358 14 1
## 529 359 17 1
## 530 360 14 1
## 531 361 15 1
## 532 362 15 1
## 533 363 15 1
## 534 363 11 2
## 535 364 15 1
## 536 364 11 2
## 537 365 15 1
## 538 365 11 2
## 539 366 11 1
## 540 367 11 1
## 541 368 11 1
## 542 369 11 1
## 543 369 6 2
## 544 370 11 1
## 545 371 16 1
## 546 372 16 1
## 547 373 16 1
## 548 373 3 2
## 549 374 9 1
## 550 374 14 2
## 551 375 9 1
## 552 375 14 2
## 553 376 9 1
## 554 376 14 2
## 555 377 6 1
## 556 378 15 1
## 557 379 9 1
## 558 380 16 1
## 559 380 14 2
## 560 381 16 1
## 561 381 14 2
## 562 382 11 1
## 563 383 5 1
## 564 384 16 1
## 565 384 3 2
## 566 385 9 1
## 567 385 14 2
## 568 386 14 1
## 569 387 12 1
## 570 388 12 1
## 571 389 12 1
## 572 389 5 2
## 573 390 10 1
## 574 391 10 1
## 575 391 2 2
## 576 392 10 1
## 577 392 2 2
## 578 393 11 1
## 579 394 11 1
## 580 395 11 1
## 581 395 9 2
## 582 396 1 1
## 583 396 3 2
## 584 397 1 1
## 585 397 3 2
## 586 398 1 1
## 587 398 3 2
## 588 399 1 1
## 589 400 1 1
## 590 400 11 2
## 591 401 7 1
## 592 402 7 1
## 593 403 13 1
## 594 404 13 1
## 595 405 13 1
## 596 406 12 1
## 597 406 4 2
## 598 407 12 1
## 599 407 4 2
## 600 408 6 1
## 601 409 6 1
## 602 410 6 1
## 603 410 9 2
## 604 411 6 1
## 605 411 9 2
## 606 412 7 1
## 607 413 7 1
## 608 413 12 2
## 609 414 7 1
## 610 414 3 2
## 611 415 7 1
## 612 415 3 2
## 613 416 7 1
## 614 416 3 2
## 615 417 13 1
## 616 418 11 1
## 617 419 11 1
## 618 420 12 1
## 619 421 12 1
## 620 422 11 1
## 621 423 11 1
## 622 423 5 2
## 623 424 1 1
## 624 425 8 1
## 625 425 3 2
## 626 426 8 1
## 627 426 3 2
## 628 427 1 1
## 629 428 1 1
## 630 429 8 1
## 631 430 17 1
## 632 430 3 2
## 633 431 1 1
## 634 432 1 1
## 635 433 14 1
## 636 434 4 1
## 637 434 17 2
## 638 435 4 1
## 639 435 17 2
## 640 436 9 1
## 641 436 14 2
## 642 437 9 1
## 643 437 14 2
## 644 438 6 1
## 645 439 14 1
## 646 439 18 2
## 647 440 1 1
## 648 441 1 1
## 649 441 3 2
## 650 442 8 1
## 651 442 17 2
## 652 443 16 1
## 653 443 5 2
## 654 444 16 1
## 655 444 5 2
## 656 445 16 1
## 657 445 5 2
## 658 446 1 1
## 659 447 2 1
## 660 448 2 1
## 661 448 9 2
## 662 449 5 1
## 663 450 5 1
## 664 451 4 1
## 665 451 7 2
## 666 452 4 1
## 667 452 17 2
## 668 453 4 1
## 669 453 2 2
## 670 454 4 1
## 671 454 2 2
## 672 455 12 1
## 673 456 11 1
## 674 457 11 1
## 675 458 11 1
## 676 458 3 2
## 677 459 12 1
## 678 459 15 2
## 679 460 12 1
## 680 460 15 2
## 681 461 17 1
## 682 461 15 2
## 683 462 13 1
## 684 462 9 2
## 685 463 1 1
## 686 464 5 1
## 687 464 6 2
## 688 465 12 1
## 689 466 13 1
## 690 467 10 1
## 691 468 18 1
## 692 468 3 2
## 693 469 7 1
## 694 469 3 2
## 695 470 12 1
## 696 471 15 1
## 697 472 5 1
## 698 472 3 2
## 699 473 15 1
## 700 473 5 2
## 701 474 1 1
## 702 475 14 1
## 703 475 2 2
## 704 476 6 1
## 705 476 9 2
## 706 477 8 1
## 707 478 15 1
## 708 478 8 2
## 709 479 13 1
## 710 479 8 2
## 711 480 14 1
## 712 481 14 1
## 713 482 14 1
## 714 483 9 1
## 715 483 16 2
## 716 484 11 1
## 717 484 16 2
## 718 485 10 1
## 719 485 9 2
## 720 486 1 1
## 721 487 8 1
## 722 487 16 2
## 723 488 14 1
## 724 489 11 1
## 725 490 11 1
## 726 491 17 1
## 727 492 12 1
## 728 493 1 1
## 729 494 14 1
## 730 494 10 2
## 731 495 12 1
## 732 496 12 1
## 733 497 12 1
## 734 498 10 1
## 735 499 10 1
## 736 499 2 2
## 737 500 10 1
## 738 500 2 2
## 739 501 11 1
## 740 502 11 1
## 741 503 11 1
## 742 504 1 1
## 743 505 1 1
## 744 506 1 1
## 745 507 1 1
## 746 508 1 1
## 747 509 17 1
## 748 510 17 1
## 749 511 12 1
## 750 512 12 1
## 751 513 10 1
## 752 514 10 1
## 753 515 11 1
## 754 516 11 1
## 755 517 14 1
## 756 518 14 1
## 757 519 1 1
## 758 519 3 2
## 759 520 1 1
## 760 520 3 2
## 761 521 1 1
## 762 521 3 2
## 763 522 13 1
## 764 523 13 1
## 765 524 6 1
## 766 525 6 1
## 767 526 6 1
## 768 527 14 1
## 769 527 3 2
## 770 528 14 1
## 771 528 3 2
## 772 529 5 1
## 773 530 5 1
## 774 530 9 2
## 775 531 1 1
## 776 532 2 1
## 777 533 2 1
## 778 534 2 1
## 779 535 11 1
## 780 536 11 1
## 781 536 5 2
## 782 537 11 1
## 783 537 5 2
## 784 538 2 1
## 785 539 2 1
## 786 540 7 1
## 787 540 12 2
## 788 541 7 1
## 789 541 12 2
## 790 542 7 1
## 791 542 12 2
## 792 543 7 1
## 793 543 4 2
## 794 544 7 1
## 795 544 4 2
## 796 545 7 1
## 797 545 4 2
## 798 546 12 1
## 799 546 18 2
## 800 547 12 1
## 801 547 18 2
## 802 548 12 1
## 803 549 12 1
## 804 550 11 1
## 805 551 5 1
## 806 551 17 2
## 807 552 5 1
## 808 552 17 2
## 809 553 5 1
## 810 553 17 2
## 811 554 10 1
## 812 555 10 1
## 813 556 12 1
## 814 557 7 1
## 815 557 6 2
## 816 558 7 1
## 817 558 6 2
## 818 559 17 1
## 819 559 2 2
## 820 560 17 1
## 821 560 2 2
## 822 561 14 1
## 823 561 3 2
## 824 562 8 1
## 825 563 8 1
## 826 564 11 1
## 827 564 6 2
## 828 565 11 1
## 829 565 6 2
## 830 566 6 1
## 831 566 3 2
## 832 567 6 1
## 833 567 3 2
## 834 568 4 1
## 835 569 4 1
## 836 570 17 1
## 837 571 17 1
## 838 572 1 1
## 839 573 1 1
## 840 574 14 1
## 841 575 14 1
## 842 576 14 1
## 843 577 14 1
## 844 578 14 1
## 845 579 14 1
## 846 580 11 1
## 847 580 3 2
## 848 581 11 1
## 849 581 3 2
## 850 582 15 1
## 851 583 15 1
## 852 584 15 1
## 853 585 1 1
## 854 585 12 2
## 855 586 1 1
## 856 586 12 2
## 857 587 13 1
## 858 587 3 2
## 859 588 7 1
## 860 589 7 1
## 861 589 9 2
## 862 590 12 1
## 863 590 4 2
## 864 591 12 1
## 865 591 4 2
## 866 592 11 1
## 867 592 8 2
## 868 593 11 1
## 869 593 8 2
## 870 594 11 1
## 871 595 7 1
## 872 595 13 2
## 873 596 7 1
## 874 596 13 2
## 875 597 12 1
## 876 597 9 2
## 877 598 12 1
## 878 598 9 2
## 879 599 9 1
## 880 600 9 1
## 881 601 9 1
## 882 602 13 1
## 883 603 13 1
## 884 604 13 1
## 885 605 14 1
## 886 606 14 1
## 887 607 8 1
## 888 607 10 2
## 889 608 8 1
## 890 608 10 2
## 891 609 8 1
## 892 609 10 2
## 893 610 16 1
## 894 611 16 1
## 895 612 16 1
## 896 613 15 1
## 897 614 15 1
## 898 615 15 1
## 899 616 7 1
## 900 617 7 1
## 901 618 5 1
## 902 618 13 2
## 903 619 2 1
## 904 620 2 1
## 905 621 16 1
## 906 622 5 1
## 907 622 8 2
## 908 623 5 1
## 909 623 8 2
## 910 624 17 1
## 911 624 9 2
## 912 625 17 1
## 913 625 9 2
## 914 626 1 1
## 915 627 1 1
## 916 627 3 2
## 917 628 1 1
## 918 628 3 2
## 919 629 17 1
## 920 629 3 2
## 921 630 17 1
## 922 630 3 2
## 923 631 10 1
## 924 632 7 1
## 925 632 9 2
## 926 633 17 1
## 927 633 16 2
## 928 634 17 1
## 929 634 16 2
## 930 635 17 1
## 931 635 16 2
## 932 636 7 1
## 933 636 10 2
## 934 637 7 1
## 935 637 10 2
## 936 638 9 1
## 937 638 2 2
## 938 639 6 1
## 939 639 2 2
## 940 640 12 1
## 941 640 2 2
## 942 641 3 1
## 943 642 13 1
## 944 642 3 2
## 945 643 16 1
## 946 643 10 2
## 947 644 16 1
## 948 644 13 2
## 949 645 5 1
## 950 645 3 2
## 951 646 16 1
## 952 646 15 2
## 953 647 11 1
## 954 647 2 2
## 955 648 1 1
## 956 648 14 2
## 957 649 7 1
## 958 649 9 2
## 959 650 12 1
## 960 651 12 1
## 961 652 12 1
## 962 652 2 2
## 963 653 10 1
## 964 654 10 1
## 965 655 10 1
## 966 655 14 2
## 967 656 11 1
## 968 657 11 1
## 969 658 11 1
## 970 658 17 2
## 971 659 1 1
## 972 660 1 1
## 973 660 5 2
## 974 661 1 1
## 975 661 3 2
## 976 662 10 1
## 977 662 3 2
## 978 663 10 1
## 979 663 3 2
## 980 664 7 1
## 981 665 7 1
## 982 666 7 1
## 983 666 3 2
## 984 667 10 1
## 985 667 1 2
## 986 668 10 1
## 987 668 1 2
## 988 669 18 1
## 989 670 18 1
## 990 671 18 1
## 991 672 12 1
## 992 673 12 1
## 993 674 2 1
## 994 675 2 1
## 995 675 17 2
## 996 676 1 1
## 997 677 14 1
## 998 678 14 1
## 999 679 9 1
## 1000 679 8 2
## 1001 680 9 1
## 1002 680 8 2
## 1003 681 9 1
## 1004 681 8 2
## 1005 682 18 1
## 1006 683 18 1
## 1007 684 18 1
## 1008 685 18 1
## 1009 686 17 1
## 1010 686 14 2
## 1011 687 17 1
## 1012 687 14 2
## 1013 688 6 1
## 1014 688 11 2
## 1015 689 6 1
## 1016 689 11 2
## 1017 690 4 1
## 1018 690 11 2
## 1019 691 4 1
## 1020 691 16 2
## 1021 692 11 1
## 1022 693 11 1
## 1023 694 13 1
## 1024 694 1 2
## 1025 695 13 1
## 1026 695 1 2
## 1027 696 6 1
## 1028 696 16 2
## 1029 697 6 1
## 1030 697 16 2
## 1031 698 6 1
## 1032 698 15 2
## 1033 699 6 1
## 1034 699 15 2
## 1035 700 18 1
## 1036 701 2 1
## 1037 701 3 2
## 1038 702 13 1
## 1039 702 18 2
## 1040 703 6 1
## 1041 703 18 2
## 1042 704 16 1
## 1043 705 16 1
## 1044 706 16 1
## 1045 707 9 1
## 1046 707 18 2
## 1047 708 8 1
## 1048 708 12 2
## 1049 709 8 1
## 1050 709 12 2
## 1051 710 8 1
## 1052 710 12 2
## 1053 711 8 1
## 1054 711 12 2
## 1055 712 15 1
## 1056 713 15 1
## 1057 714 3 1
## 1058 714 16 2
## 1059 715 3 1
## 1060 715 16 2
## 1061 716 18 1
## 1062 717 17 1
## 1063 717 3 2
## 1064 718 16 1
## 1065 718 5 2
## 1066 719 6 1
## 1067 719 18 2
## 1068 720 14 1
## 1069 720 8 2
## 1070 721 10 1
## 1071 721 11 2
## 1072 10001 14 1
## 1073 10002 14 1
## 1074 10003 14 1
## 1075 10004 7 1
## 1076 10004 5 2
## 1077 10005 7 1
## 1078 10005 9 2
## 1079 10006 12 1
## 1080 10006 3 2
## 1081 10007 8 1
## 1082 10007 16 2
## 1083 10008 13 1
## 1084 10008 10 2
## 1085 10009 13 1
## 1086 10009 11 2
## 1087 10010 13 1
## 1088 10010 15 2
## 1089 10011 13 1
## 1090 10011 3 2
## 1091 10012 13 1
## 1092 10012 12 2
## 1093 10013 10 1
## 1094 10014 11 1
## 1095 10015 15 1
## 1096 10016 11 1
## 1097 10017 10 1
## 1098 10017 14 2
## 1099 10018 1 1
## 1100 10018 2 2
## 1101 10019 3 1
## 1102 10020 13 1
## 1103 10020 3 2
## 1104 10021 5 1
## 1105 10021 3 2
## 1106 10022 16 1
## 1107 10022 15 2
## 1108 10023 16 1
## 1109 10023 15 2
## 1110 10024 11 1
## 1111 10024 2 2
## 1112 10025 14 1
## 1113 10026 9 1
## 1114 10026 8 2
## 1115 10027 8 1
## 1116 10027 12 2
## 1117 10028 8 1
## 1118 10028 12 2
## 1119 10029 8 1
## 1120 10029 12 2
## 1121 10030 8 1
## 1122 10030 12 2
## 1123 10031 8 1
## 1124 10031 12 2
## 1125 10032 8 1
## 1126 10032 12 2
## 1127 10033 12 1
## 1128 10033 4 2
## 1129 10034 10 1
## 1130 10034 16 2
## 1131 10035 10 1
## 1132 10035 3 2
## 1133 10036 11 1
## 1134 10037 14 1
## 1135 10038 8 1
## 1136 10038 4 2
## 1137 10039 1 1
## 1138 10040 7 1
## 1139 10040 3 2
## 1140 10041 11 1
## 1141 10041 17 2
## 1142 10042 6 1
## 1143 10042 3 2
## 1144 10043 14 1
## 1145 10043 2 2
## 1146 10044 14 1
## 1147 10045 13 1
## 1148 10045 16 2
## 1149 10046 7 1
## 1150 10046 9 2
## 1151 10047 7 1
## 1152 10047 2 2
## 1153 10048 17 1
## 1154 10048 10 2
## 1155 10049 6 1
## 1156 10049 17 2
## 1157 10050 10 1
## 1158 10050 2 2
## 1159 10051 14 1
## 1160 10051 18 2
## 1161 10052 9 1
## 1162 10052 18 2
## 1163 10053 9 1
## 1164 10054 2 1
## 1165 10054 14 2
## 1166 10055 13 1
## 1167 10056 8 1
## 1168 10057 17 1
## 1169 10058 16 1
## 1170 10058 5 2
## 1171 10059 2 1
## 1172 10059 9 2
## 1173 10060 12 1
## 1174 10060 15 2
## 1175 10061 18 1
## 1176 10062 16 1
## 1177 10062 14 2
## 1178 10063 16 1
## 1179 10063 14 2
## 1180 10064 11 1
## 1181 10064 5 2
## 1182 10065 12 1
## 1183 10065 16 2
## 1184 10066 17 1
## 1185 10066 8 2
## 1186 10067 16 1
## 1187 10067 18 2
## 1188 10068 14 1
## 1189 10068 2 2
## 1190 10069 1 1
## 1191 10069 18 2
## 1192 10070 11 1
## 1193 10070 17 2
## 1194 10071 11 1
## 1195 10071 14 2
## 1196 10072 9 1
## 1197 10072 5 2
## 1198 10073 1 1
## 1199 10073 3 2
## 1200 10074 15 1
## 1201 10075 6 1
## 1202 10075 18 2
## 1203 10076 9 1
## 1204 10076 14 2
## 1205 10077 11 1
## 1206 10078 5 1
## 1207 10078 10 2
## 1208 10079 16 1
## 1209 10079 3 2
## 1210 10080 13 1
## 1211 10081 13 1
## 1212 10082 13 1
## 1213 10083 13 1
## 1214 10084 13 1
## 1215 10085 13 1
## 1216 10086 14 1
## 1217 10086 17 2
## 1218 10087 10 1
## 1219 10087 5 2
## 1220 10088 1 1
## 1221 10088 2 2
## 1222 10089 16 1
## 1223 10089 3 2
## 1224 10090 7 1
## 1225 10090 4 2
dbGetQuery(pokemonDatabase, "PRAGMA FOREIGN_KEY_LIST(pokemon_types)")
## id seq table from to on_update on_delete match
## 1 0 0 types type_id id NO ACTION NO ACTION NONE
## 2 1 0 pokemon pokemon_id id NO ACTION NO ACTION NONE
dbGetQuery(pokemonDatabase, "
SELECT *
FROM types")
## id identifier generation_id damage_class_id
## 1 1 normal 1 2
## 2 2 fighting 1 2
## 3 3 flying 1 2
## 4 4 poison 1 2
## 5 5 ground 1 2
## 6 6 rock 1 2
## 7 7 bug 1 2
## 8 8 ghost 1 2
## 9 9 steel 2 2
## 10 10 fire 1 3
## 11 11 water 1 3
## 12 12 grass 1 3
## 13 13 electric 1 3
## 14 14 psychic 1 3
## 15 15 ice 1 3
## 16 16 dragon 1 3
## 17 17 dark 2 3
## 18 18 fairy 6 NA
## 19 10001 unknown 2 NA
## 20 10002 shadow 3 NA
dbGetQuery(pokemonDatabase, "PRAGMA FOREIGN_KEY_LIST(types)")
## id seq table from to on_update on_delete match
## 1 0 0 move_damage_classes damage_class_id id NO ACTION NO ACTION NONE
## 2 1 0 generations generation_id id NO ACTION NO ACTION NONE
dbDisconnect(pokemonDatabase)